3.1.2 Using a Named Condition
You can use a Named Condition in any Worksheet that shares the same scope as the Named Condition. (See Creating a Named Condition for information on creating Named Conditions.)
To add a Named Condition to a table in a Worksheet, follow these steps:
1. Drag the Named Condition asset from the Asset Repository tree to an empty cell in the Worksheet. This creates a Named Condition object in the Worksheet.
2. Drag the new Named Condition object until its border touches the border (left or right) of the table to which you want to add the condition.

3. When the “filter” icon appears, release the Name Condition object.
The Named Condition is applied to the table. If the Named Condition references attributes that do not already exist in the table, these attributes are added to the table as invisible columns.
You can add multiple Named Conditions to a single table by repeating the above steps. These Named Conditions, as well as any conditions internal to the table itself, are joined together by AND operators to yield the final data filter.
This example continues from the example in Extracting a Named Condition from a Table. You will create a new Data Worksheet which contains a table using the 'NJ Orders' query. If you want to filter the data in that table so that only the orders with a discount value greater than 0.2 are included, instead of specifying that condition for the table, you can use the 'Large Discount' Named Condition and associate it with the table.

1. Create a new Worksheet.
2. Expand the 'Data Source' node, the 'Orders' node, and the 'DWS' node.
3. Drag the 'NY Orders' query onto an empty cell on the Worksheet. This creates a new table, 'NY Orders1'.
4. Expand the 'Global Worksheet' node.
The condition name is shown in italics to indicate that the condition asset is referenced from another Worksheet.
5. Select the 'Large Discount' Named Condition and drag it onto an empty cell in the Worksheet. This adds a named condition called 'Large Discount1' to the Worksheet.

Note: Drag the title bar to move the object. (Do not drag the filter icon in the title bar.)
6. Drag the Named Condition object to be right next to the 'NY Orders1' table until the mouse changes into the condition icon.

7. Release the mouse. The condition is added to the table.
8. Select the 'NY Orders1' table. Notice that a link is created between the 'NY Orders1' table and the 'Large Discount1' Named Condition.
9. Preview the table. (See Previewing a Table.) Notice that only the orders with a discount value greater than 0.2 are included in the table.

| << Using a Data Table within a Worksheet | © 1996-2013 InetSoft Technology Corporation (v11.4) | 3.1.3 Using a Named Grouping >> |