|
<< Click to Display Table of Contents >> Filter Data Using Filters |
  
|
|
<< Click to Display Table of Contents >> Filter Data Using Filters |
|
Users can use filters to filter the data. Filtering data can be implemented on components that display data. You need to bind data before you can set filters. Filters that you set can be copied to the same components.
❖Filter implementation steps
1) Select the component, click Filter on the settings page of the right panel, open the filter dialog box, and click the Add Filter Condition prompt to add the filter condition.
2) Set filter conditions.
3) After adding a filter condition, you can operate the filter condition, remove it, insert the filter condition below, insert the filter condition above, clear the filter condition, as shown in the figure below.
[Delete] Click Delete to remove the current filter condition.
[insert filter conditions below] You can add filter conditions below the current filter conditions.
[Insert filter conditions above] You can insert a filter condition above the current filter condition.
4) The relationship between the two filter conditions includes the relationship between and, or. Right-click on the relationship row, and in the right-click menu there are Delete, Convert to or / Convert to AND, and Exchange Subconditions.
[Delete] Delete the upper and lower two filter conditions of this line. That is, delete the filter that owns this filtering relationship.
[Translate to or / Convert to] Interchange between two levels of screening conditions.
The [Node forward indentation] node is indented to the previous level. The first sub-condition of the current node can be combined with the filter condition above the current node and at the same level.
[Nodes are indented backwards] Nodes are indented one level ahead. The first sub-condition of the current node can be combined with the first sub-condition of the second sub-condition.
[Exchange conditions] Exchange the location of filter conditions of the same level. As shown in the following figure, the conditions in both boxes are the same level, with the lower red border being the sub-condition of the upper blue border.
After exchanging sub-conditions, the filter conditions in the above figure change to the conditions shown in the figure below.
❖Filter settings
The filter condition is set according to the data segment of the bound query, where the data segment contains all the data segments in the query except for the aggregated expression created in the dashboard.
Different data types contain different filter conditions, as shown in the following table:
type of data |
Supported statements |
|---|---|
Boolean |
"None"， "=" |
Date, time, timestamp |
"None"，"="， ">"，">="， "<"， "<="， "between"， "One of the" |
Long integer |
"In the circle"，"Within the rectangle"，"="， ">"，">="， "<"， "<="， "contain"， "Start"，"between"，"contain one of the"，"One of the"，"None" |
other |
"="， ">"，">="， "<"， "<="， "contain"， "Start"，"between"，"contain one of the"，"One of the"，"None" |
The date, time, and timestamp type of data display calendar buttons.
"In between" will pop up two input boxes for entering initial value and ending value.
"One of the", "contain one of the" can add multiple values, and the added values can be edited via the "Add" and "Delete" buttons.
"In the circle" needs to add 3 parameter values and must be added in order. The values to be added are: longitude value, latitude value, radius (meters).
"In the rectangle" needs to add 4 parameter values and must be added in order. The values to be added are: Longitude, Latitude, Width (m), Height (m).
Only Long Integer data (for example: position column pos indicating latitude and longitude) has filter conditions within "in the circle" and "in the rectangle".
The filter condition value also supports some system parameters. The GUI only shows _USER_, _GROUP_, _ROLE_, _ROLES_, _BLANK_. Others are advanced parameters that are no longer displayed on the GUI. Please refer to the list of built-in parameters when using them.
➢E.g: When the component being filtered has a null value and is an empty string instead of null, the filter condition should be xxx equal to ?{_BLANK_}.
More system parameters are shown in the table below.
Built-in parameter list
parameter name |
Instructions |
|---|---|
_USER_ |
Return the current user name |
_GROUP_ |
Return the current user's group name |
_ROLE_ |
Return the current user's role |
_ROLES_ |
Returns the current user's role (multiple roles) |
_BLANK_ |
Return null value in data |
_LAST_YEAR_ |
Returns the previous year of the current time. The value is an integer. If this year is 2013, the return value is 2012. |
_THIS_YEAR_ |
Returns the year of the year and the value is an integer |
_NEXT_YEAR_ |
Returns the year of the next year, the value is an integer |
_LAST_QUARTER_ |
Returns the previous quarter's value in the current quarter. The value is an integer |
_THIS_QUARTER_ |
Returns the current quarter value as an integer |
_NEXT_QUARTER_ |
Returns the next quarter's value for the current quarter. The value is an integer |
_LAST_MONTH_ |
Returns the previous month's value of the current month. The value is an integer |
_THIS_MONTH_ |
Returns the current month value as an integer |
_NEXT_MONTH_ |
Returns the next month's value of the current month as an integer |
_LAST_WEEK_ |
Returns the value of the previous week in the current week of the year. The value is an integer. If today is 2013-01-18, it is the third week in 2013, the return value is 2 |
_THIS_WEEK_ |
Return the current date is the week of the year, the value is an integer, as today is 2013-01-18, is the third week in 2013, the return value is 3 |
_NEXT_WEEK_ |
Returns the value of the next week in the current week of the year. The value is an integer. If today is 2013-01-18, it is the third week in 2013, the return value is 4 |
_LAST_DAY_ |
The day before the return date of the current date is the number, the value is an integer, such as today is 2013-01-18, the return value is 17 |
_THIS_DAY_ |
Return the current date is the number, the value is an integer, such as today is 2013-01-18, the return value is 18 |
_NEXT_DAY_ |
Return the current date of the next day is the number, the value is an integer, such as today is 2013-01-18, the return value is 19 |
_LAST_YEAR_QUARTER_ |
Returns the first day of the previous quarter in the current quarter. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-01-01 00:00:00 |
_THIS_YEAR_QUARTER_ |
Return the first day of the current quarter, the return value is a timestamp type, if today is 2013-04-18, the return value is 2013-04-01 00:00:00 |
_NEXT_YEAR_QUARTER_ |
Returns the first day of the next quarter of the current quarter. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-07-01 00:00:00 |
_LAST_YEAR_MONTH_ |
Returns the first day of the previous month of the current month. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-03-01 00:00:00 |
_THIS_YEAR_MONTH_ |
Return the first day of the current month, the return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-01 00:00:00 |
_NEXT_YEAR_MONTH_ |
Returns the first day of the next month of the current month. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-05-01 00:00:00 |
_LAST_YEAR_WEEK_ |
Returns the first day of the previous week of the current week. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-07 00:00:00. Note that the week is calculated according to the specifications provided by java, taking Sunday as the starting point of the week |
_THIS_YEAR_WEEK_ |
Return the first day of the current week, the return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-14 00:00:00 |
_NEXT_YEAR_WEEK_ |
Returns the first day of the next week of the current week. The return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-21 00:00:00. |
_LAST_FULL_DAY_ |
The day before the current date is returned, the return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-17 00:00:00 |
_THIS_FULL_DAY_ |
Return the current date, the return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-18 00:00:00 |
_NEXT_FULL_DAY_ |
The day after the return of the current date, the return value is a timestamp type. If today is 2013-04-18, the return value is 2013-04-19 00:00:00 |
_LAST_WEEKDAY_ |
The day before the current date is returned is the day of the week. The return value is an integer. If today is 2013-04-18, the return value is 4. Note that the week is calculated according to the specifications provided by java, taking Sunday as the starting point of the week |
_THIS_WEEKDAY_ |
Return the current date is the day of the week, the return value is an integer, such as today is 2013-04-18, the return value is 5 |
_NEXT_WEEKDAY_ |
The day after the return of the current date is the day of the week. The return value is an integer. If today is 2013-04-18, the return value is 6. |
❖Copy filter
Right-click on the component and select Filter - Copy Filter to copy the filter on the component to other components that are bound to the same data source.
➢E.g
Set the filter condition on table 1: MARKET_SIZE is equal to [Major Market], then right click on table 1 to select filter - copy filter, right click on table 2 to select filter - paste filter, then the filter is copied to table 2 On the.
If there is a filter on table 2, it will prompt: The new filter condition will replace the original filter condition. Continue? Click Yes, the original conditions of Form 2 have been replaced; click No, the original conditions of Form 2 remain.
➢Precautions
1) After removing a component that has a filter set, the corresponding filter is also deleted, but after clearing all bound data, the filter does not disappear and it still works.
2) If parameters need to be set in the filter condition, the parameter writing format is ?{param}, and the question mark must be entered in English.