Configuring Stored Filters
When using RDM, the filter can load preconfigured queries for ease of access as well as save the filters directly in the web application.
-
In the App Variables node, switch to the Search tab.
-
To create a new search definition, select Add in the search panel.
-
Click the row number of the new search filter to open the editing panel.
-
By selecting Enable, your search definitions appears in the My Saved Filters section of the filters.
-
Enter the Name which will appear in the filter.
-
Press Ctrl+Space to get a list of entities and select the one you wish to configure the filter for.
-
Select Join by OR if you wish to use an OR operator. The default setting uses the AND operator.
-
If the basic filtering is not enough, it is possible to write an advanced condition in the Advanced SQL Condition column.
Advanced filtering also allows to refer to default columns, like [ State ] or [ Valid ], using the same syntax as in the webapp advanced filters, for example, "[ State ]" = 'Edited'. -
Next, under Columns, add columns that will be available to users in this search definition. Press Ctrl+Space to get a list of available columns.
-
Double-click the Default Operators column to get a list of all available operators.
-
Enter the Default Value you wish to filter by.
-
Finally, if you wish to make search case sensitive, select Case Sensitive.
-
Select Apply.
-
Select the left arrow and repeat steps 2-13 to add another search definition.
Was this page useful?