How to include items in a Restriction Rule

Use the following information to include specific types of items in a restriction rule.

Constants

Position the cursor in the top area and type the constant.

Table items

Step 1. In the bottom left portion of the tab, double-click Tables to display a list of selected tables.

Step 2. Double-click the name of the table that contains the table item you want to include.

Step 3. In the bottom right section of the tab, double-click the name of the table item to include in the query/report.

The name of the table item displays in the restriction rule at the top of the tab.

User-defined items

Step 1. In the bottom left portion of the tab, double-click User-defined items to display a list of user-defined items for the current query or report.

Step 2. In the bottom right section of the tab, double-click the user-defined item to include in the query/report.

The name of the user-defined item appears in the restriction rule in the area at the top of the tab.

Operators

Step 1. In the bottom left portion of the tab, double-click Operators to display a list of operators.

Step 2. In the bottom right section of the tab, double-click the operator to include in the query/report. In addition to the items offered on the list of operators, you can use any other operator that the FASuite relational database management system supports. Refer to your database documentation for a list of available operators and functions.

The name of the user-defined item displays in the restriction rule at the top of the tab.

Functions

Step 1. In the bottom left portion of the tab, double-click Functions to display a list of functions.

Two choices appear:

String Functions
Numeric Functions

If you click either String functions or Numeric functions, the functions display in the right section of the tab.

Step 2. Double-click the function to include it in the query/report. In addition to the items offered on the list of functions, you can use any other function that the FASuite relational database management system supports. Refer to your database documentation for a list of available operators and functions.

Prompt Function

The Prompt function instructs the system to prompt you for a value when you run a query or report.

If you choose Prompt, a prompt expression displays in the top area of the tab. Position the cursor between the colon and the closing angle bracket (>) and type the label for the prompt. This label appears as the title of a prompt window when you run the query or report.

To insert a prompt:

Step 1. Position the cursor in the top area.

Step 2. Type <PROMPT:>.

Step 3. Position the cursor between the colon and the closing angle bracket (>).

Step 4. Type the label for the prompt.

You can type additional parts of the restriction rule, such as filter information, directly in the top area of the tab. If your organization has user groups that use different report formats to print data from the same screen, it can be useful to specify different filter restrictions to the report for each group. Refer to Defining query/report filter restrictions for specific user groups.

_______________