5.2.1 Creating a Filter Condition
To apply a condition to a data view or output component, follow these steps:
1. Right-click the element, and select 'Condition' from the context menu. This opens the 'Condition' dialog box.

2. Select the operand and type of comparison from the menus at the top of the dialog box, e.g., “[Company][is not][one of]”

3. From the 'Change Value Type' popup menu (triangle), select 'Value', 'Field', 'Variable', or 'Session Data'.
a. If you select the 'Field' option, in the adjoining menu, choose the column for comparison. (The two columns will be compared row by row; rows that satisfy the condition will be preserved.)
b. If you select the 'Value' option, either enter the comparison value into the provided text field, or select 'Browse Data' to choose the comparison value from a list.
c. If you select the 'Variable' option, select one of the Input Components listed in the menu to provide the value at runtime. (See Dynamic Properties for further details.)
d. If you select the 'Expression' option, press the 'js'/'sql' button to select JavaScript or SQL syntax, and then press the 'Edit' button. This opens the Script Editor where you can enter your expression. (See Adding Property Script (Expressions) in Dashboard Scripting for details on using expressions.)
Note that the adjacent menu automatically chooses the 'equal to' or 'one of' operator to match your selection.
e. If you select the 'Session Data' option, choose one of 'User', 'Roles', or 'Groups'. These parameters return information about the user who is currently viewing the Viewsheet; respectively, the user name, the array of roles to which the user belongs, and the array of groups to which the user belongs.
4. When you have fully specified the condition, click 'Append'.
5. To create a compound condition, repeat Steps 2-4 above, using the 'and' and 'or' operators to compose the condition clauses. See Modifying a Filter/Highlight Condition for more details.
6. Click 'OK' to exit the 'Condition' dialog box.
The component will only display data that is compatible with the selections and satisfies the condition.
See Also
Filtering Table Columns, for an alternative method of filtering tables.
Filtering Operators, in Data Mashup, for explanation of the operators.
| << 5.2 Filter Conditions | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.3 Hyperlinks >> |