Panel Filter

The Panel Filter is a set of conditions that are applied to the rows in the panel. When the user selects records in other panels, the corresponding filter conditions are applied.

If checked, this filter will be included in the panel's filter information, which the user can view by clicking the filter icon in the panel's header.

You can add text to be shown as the description of the filter.

In this example, a map panel is filtered to show only those map points for people (Points panel) whose Text1 field matches the Fruit panel's Text1 field. So when the user clicks on a fruit in the list, the map is filtered only to show those points for which the fruit has been selected. You can apply multiple conditions and drag/drop them into the most efficient sequence. The first that returns true applies and stops further conditions being checked.

To add a condition, give it a name and then enter Value 1 and Value 2 (using placeholders) and select the way in which they should be compared. If the values are to be compared other than as text, select the format: Number, Date/Time or Boolean (Yes/No). The comparison options are:

• Equal to each other
• Not equal to each other
• Value 1 less than Value 2
• Value 1 less than or equal to Value 2
• Value 1 greater than Value 2
• Value 1 greater than or equal to Value 2
• Value 1 contains the text of Value 2
• Value 1 does not contain the text of Value 2
• Value 1 starts with the text of Value 2
• Value 1 ends with the text of Value 2

The Always option indicates, when checked, that if no record is selected in any of the referenced panels (other than this panel), show all rows (otherwise none will be shown).