Use the advanced admin filters to get the exact data you need from the admin panel.
Can I Search The Column For Which I Would Like To Apply The Filter?
Yes, you can search the column by using the search box that is present above the field columns. This makes it easier for the user to find the column and apply the criteria for their search.
All the management list screens will have a filter option. The filter will be present on the left side. All the columns will be listed in the filter menu.
Text
Numbers
Dates
Checkboxes
Dropdowns
Predefined statuses
What Are The Different Types Of Data That Can Be Searched Using This Filter?
Column data that has the following field types will have the filter present on the left side.
Status
Text
Number
Date
Checkbox
Dropdown
Status Field
If the column data value is a predefined set of statuses that are in the process flow(Ex: Active, Inactive statuses), then the following condition drop-down should be displayed
Equals to
Not Equals to
is empty
is not empty
After choosing the condition filter value from the above list, the available status will be shown in the autocomplete. On choosing the status value using autocomplete and clicking the “Filter” button, list data will be filtered based on the provided “Status” value and the condition
Text Field
If the column data value is “Text” then the below text filter condition drop-down will be displayed.
Operator | Purpose | Example |
Equal to | Returns a result identical to the data entered in the second Value column. | Last name (@lastName) equal to 'Jones,' will return only recipients whose last name is Jones. |
Not equal to | Returns all values not identical to the value entered. | Language (@language) not equal to 'English' will return data that is not equal to the English language |
Contains | Returns the results containing at least the value entered. | Email domain (@domain) contains 'mail', and will return all domain names that contain 'mail'. So the 'gmail.com' domain will also be returned. |
Does not contain | Returns result not containing the value entered. | The email domain (@domain) does not contain 'vo.' In this case, domain names that contain 'vo' will not be returned. The 'voila.fr' domain name will not appear in the results. |
Starts with | Returns the results starting with the value entered. | Listing# (@Listing) starts with Chennai. |
Ends with | Returns the results ending with the value entered. | Listing# (@Listing) ends with Chennai. |
Is Empty | If the value is empty |
|
Is not empty | If the value is not empty |
|
After choosing the condition filter value from the above list, a text box will be enabled for the users to search the text. On entering the text in the “text box“ and clicking the “Filter” button, list data will be filtered based on the provided “text“ value and the condition.
Number Field
If the column data value is “Number” then the below Number filter condition drop-down will be displayed.
Operator | Purpose | Example |
Equal To | Returns a result identical to the data entered in the second Value column. | Age(@Age) equal to 65, will return only recipients whose age is 65 |
Not Equal To | Returns all values not identical to the value entered. | Age(@Age) not equal to 65, will return only recipients whose age is not equal to 65 |
Less Than | Returns a value smaller than the value entered. | *Creation date (@created) before ‘DaysAgo(100),' will return all recipients created less than 100 days ago. ie. ‘*’99’,'98' |
Less Than Or Equal To | Returns all values equal to or lower than the value entered. | Age (@age) less than or equal to '60,' will return all recipients aged 60 or less. |
Greater Than | Returns a value greater than the value entered. | Age (@age) greater than 50, will return all values greater than '50', i.e. '51', '52', etc. |
Greater Than Or Equal To | Returns all values equal to or greater than the value entered. | Age (@age) greater than or equal to '30,' will return all recipients aged 30 or more. |
Between | Returns all values between “From” and “To” values entered. | Age (@age) Between ‘50' and '60,’ will return all recipients aged between 50 and 60 |
Not Between | Returns all values excluding values between entered“From” and “To” values. | Age (@age) Between ‘50' and '60,’ will return all recipients excluding recipients aged between 50 and 60 |
Starts With | Returns the results starting with the value entered. | Account # (@account) starts with '32010'. |
Ends With | Returns the results ending with the value entered. | Account # (@account) ends with '32010'. |
Is Empty | If the value is empty |
|
Is Not Empty | If the value is not empty |
|
After choosing the condition filter value from the above list, a number box will be enabled for the user to search the number. On entering the number value in the “number box“ and clicking the “Filter“ button, list data will be filtered based on the provided “number“ value and the condition.
If the user has chosen the filter condition as “Between” then 2 number boxes will be enabled and the data will be filtered based on the provided between values.
If the column data value is “Phone Number” then the below Phone Number filter condition drop-down will be displayed.
Operator | Purpose | Example |
Equal to | Returns a result identical to the data entered in the second Value column. | Phone Number# (@Phone number equal to 555-555-5555, will return only recipients whose phone number is 555-555-5555 |
Not equal to | Returns all values not identical to the value entered. | Phone Number# (@Phone number not equal to 555-555-5555, will return only recipients whose phone number is not equal to 555-555-5555. |
Starts with | Returns the results starting with the value entered. | Phone Number# (@Phone number) starts with '555-555'. |
Ends with | Returns the results ending with the value entered. | Phone Number# (@Phone number) ends with '555-555'. |
Is empty | If the value is empty |
|
Is not empty | If the value is not empty |
|
Date Field
If the column data value is “Date“ then the below Date filter condition drop-down will be displayed.
Operator | Purpose | Example |
On | On choosing this a single date picker field will be enabled for selecting a particular date. Data will be filtered for that particular date that has been selected. | Updated On# (@Updated On) Approved On '23/04/2022' Data which is updated on '23/04/2022' |
Before | On choosing this a single date picker field will be enabled for selecting a particular date. All data before the selected date will be displayed. | Created# (@Created) Before '23/04/2022' Data which is created before '23/04/2022' |
After | On choosing this a single date picker field will be enabled for selecting a particular date. All data after the selected date will be displayed. | Created# (@Created) After '23/04/2022' Data which is created after '23/04/2022' |
Between | On choosing this 2 date picker fields “From Date“ and “To Date“ will be enabled. Data will be filtered between the selected dates. | Created# (@Created) Between '23/04/2022' and '23/06/2022' Data which is created between '23/04/2022' and '23/06/2022' |
in the last | On choosing this number box and dropdown field will be enabled. The dropdown field will have “Days, Week and Month“ | Number Box= 5 Dropdown= Days Then data for the last 5 days will be displayed.
Number Box= 5 Dropdown= Week Then data for the last 5 weeks will be displayed.
Number Box= 5 Dropdown= Month Then data for the last 5 Months will be displayed. |
Today | Displays the data for today will be displayed |
|
Yesterday | Displays the data for Yesterday will be displayed |
|
This Week | Displays the data for the current week will be displayed |
|
This Month | Displays the data for Current month will be displayed |
|
This Year | Displays the data for the current year will be displayed |
|
Last Week | Displays the data for Last week will be displayed |
|
Last Month | Displays the data for Last month will be displayed |
|
Last Year | Displays the data for Last year will be displayed |
|
Is empty | If the value is empty |
|
Is not empty | If the value is not empty |
|
Checkbox Field
If the field type is “Checkbox“ then following conditions will be enabled
Equals to
Not Equals to
is empty
is not empty
After choosing the condition filter value from the above list, available checkbox values will be shown in the autocomplete. On choosing the checkbox value using autocomplete and clicking “Filter“ button, list data will be filtered based on the provided “checkbox“ values and the condition.
Drop-Down Field
If the field type is “Drop down“ then following conditions will be enabled
Equals To
Not Equals To
Is Empty
Is Not Empty
After choosing the condition filter value from the above list, available Drop down values will be available in the autocomplete. On choosing the Drop down value using autocomplete and clicking “Filter” button, list data will be filtered based on the provided “Drop-down” values and the condition.
On clicking the Apply Filter button chosen filters will be applied and data will be displayed.
On clicking the Clear button chosen filters will be cleared and data will be displayed.