Data Filters can be configured to restrict records visibility based on defined criteria. The configuration can be done by adding and deleting a filter condition.
Click Filters
option shown in the data design view window. Data filter window opens.
Add a filter condition through clicking the Add
button in the Query Filters
window.
Now, a filter condition will get added by default like below:
You can filter values with or without Null
by checking or unchecking the Include Null
option. If you check this option, only Equals
and Does Not Equal
condition will be shown like below. Based on these conditions, you may filter values with or without Null
.
Modify the condition as you require and define criteria. The condition can be defined based on the column. Based on its data type, the parameters to define will differ.
With the date time type or text type column like above, you may get a toggle button TOP āNā at right, to enable the Top N
filter to configure the field and the condition by which it has to be applied.
Below example shows top 5 freight data of a city.
For numeric type column, the parameters will be like below:
Below example shows data of freight whose values are greater than 500.
On clicking OK
in above dialog, Data Preview grid will be like below,
For date time type column, the parameters will be like below:
Below example shows data within the applied date range.
To add more than one condition, click the Add
button.
NOTE: By default, AND operation will be handled in between two conditions. The operator can be changed to OR operation if needed.
Click OK
to save defined data filter conditions.
Click Close
button or the Close icon at top right corner of the window to close the Filters window.
You can remove a filter condition by clicking the highlighted icon at right of the respective filter condition.