In the Standard Table (class name: obj_table02), it is possible to set font color, background color, row visibility and replace a cell value with an image based on the value of individual columns, rows and cells. NOTE: It is recommended that you attach the table to data before attempting to define filters.

In the Object Properties window, double-click on filterProperties in the Property Name field to bring up the Filter Properties dialog. To create a filter, click on the Add button. Double-click on an existing filter to edit. Click the Remove button to delete a filter. Click Clear to remove all filters. Use the Move Up and Move Down buttons to control in what order filters will be applied to the table.

Filters are applied to the table in the order they are listed in the Filter Properties dialog. For example, in the table below, cells that are marked On Site are set to display a background color of green. However, table rows that are marked On Site and contain the SOLARIS system have a background color of gray throughout the entire row. The setting for the SOLARIS row background color overrides the setting for the On Site cell background color because the filters are being applied in the order they are listed above.


Create a Filter
In the Object Properties dialog, double-click in the Property Name field to open the Filter Properties dialog, then click Add. The Edit Filter dialog opens. Each filter is composed of three elements: Condition, Action and Target:

Condition
Define the condition a cell must meet for the filter to be applied. Select a comparison field from the first drop down menu. The comparison field is typically the name of a column (e.g.: On Site) that contains the value (e.g.: true) to which you would like to apply a filter. The comparison field menu is populated with column names based on the table's data attachment, along with the options Row Name and Column Header. You may enter the name of a substitution or variable to use as the value of this field. Select Row Name to filter based on the value of a row name. Select Column Header to filter based on the value of a column header. 

NOTE: If you have not attached the table to data, the only values listed in this menu will be Row Name and Column Header.

In the second drop down menu, select an operator (e.g.: =, >, <, etc.) for the comparison.

In the third drop down menu, select what value the comparison field must correspond to in order for the cell to meet the condition. The comparison value menu is populated with values from the table's data attachment, based on the selected comparison field, along with the options top(5) and bottom(5). Select top(5) to apply the filter to rows or cells that contain the five highest values in the selected comparison field.  Select bottom(5) to apply the filter to rows or cells that contain the five lowest values in the selected comparison field. Once a selection is made from the comparison value menu, it is possible to edit the number of rows you would like to filter. You may enter the name of a substitution or variable to use as the value of this field.

NOTE: If you have not attached the table to data, the only values listed in this menu will be top(5) and bottom(5).

Action
Define the action that will be applied to cells, columns or rows that meet the condition. Select one of four actions from the first drop down menu.  Select Set Background Color to control the color of cells. Select Set Font Color to control the color of text. Select Hide Rows to control the visibility of rows. Select Display Image to replace a cell value with an image. 

The second drop down menu is populated with options based on which action is chosen in the first drop down menu. Depending on the action you select; choose which color to apply to the background or font, enter or select an image, or enter the name of a variable or substitution to use as the value of this field.

NOTE: The Hide Rows action only targets rows.

Target
Control how the filter is applied. There are three targets available. Select Rows to apply the filter to the entire row, if the cell from the comparison field in that row meets the condition. Select Cells to apply the filter to individual cells from the comparison field that meet the condition. Select Columns to apply the filter to the entire comparison field column, if any cell in that column meets the condition.

NOTE: The target does not apply if you chosen Hide Rows as an action.