Filter
- Products Admin
A filter is a program or section of code that is designed to examine each input or output request for certain qualifying criteria and then process or forward it accordingly.
Filter that reads data in and manipulates the data to fit another output pattern or removes data that may not be needed.
In the filter field, we are using two main operators:
(1) AND:
The logical AND operator is an operator that performs logical conjunction on two statements. It only yields a value of "true" when both statements are true. If one of the two statements is false, then the logical AND operator yields a "false" value.
(2) OR:
The OR operator is a Boolean operator which would return the value TRUE or Boolean value of 1 if either or both of the operands are TRUE or have a Boolean value of 1.
Fields:
Filter Field will map the variable to the actual column data. The filter widget connected to the variable then knows which categories are available, and can present the drop-down menu of those categories.
Filter Operators:
Equals:
The equality operator is used to compare two values or expressions. It is used to compare numbers, strings, Boolean values, variables, objects, etc. The result is TRUE if the expressions are equal otherwise it's FALSE.
Not Equals:
Valid for a column that contains text, numbers,s, or dates. Specify a single value or multiple values. Results include only records where the data in the columns does not match the value in the filter. Compares two operands to determine if the first operand is not equal to the second operand.
Start With:
Results include only records where the data in the column begins with the value in the filter.
Contains:
Results include only records where the data in the column contains all of the values in the filter. And, on the contrary, results include only records where the data in the column does not contain any of the values in the filter.
End With:
Results include only records where the data in the column ends with the value in the filter.
In:
(Bug in Operator)
Greater Than:
Results include only records where the data in the column is greater than the value in the filter.
Less Than:
Results include only records where the data in the column is less than the value in the filter.
Greater Than or Equal To:
Results include only records where the data in the column is greater than or the same as the value in the filter.
Less Than or Equal To:
Results include only records where the data in the column is less than or the same as the value in the filter.
Source Type:
(A) Static:
By using the Static source type, results include only records from the selected field. Result fetching by the value which has been added under the Static.
Steps to do:
Click on “Filter”
Select the [+] icon to create New Condition.
Select an appropriate “Field & Operator” from the drop-down.
Choose Source Type as a “Static”.
Input value which needs to fetch in result & then “Save”.
(B) Cookie Key:
By using Cookie Key, the result is fetched by the value which has been added under the Cookie Key. But, have to make sure that the value which we are adding is from the value of the cookie.
Steps to do:
Click on “Filter”
Select the [+] icon to create New Condition.
Select an appropriate “Field & Operator” from the drop-down.
Choose Source Type as a “Cookie Key”.
Open the Inspect by right-clicking on the respected object’s list view.
Find the “Cookies“ from the Application tab.
Paste Cookies value which needs to fetch in result & then “Save”.
(C) User:
By using the User source type, the result is fetched by the value which has been added under the User.
Steps to do:
Click on “Filter”
Select the [+] icon to create New Condition.
Select an appropriate “Field & Operator” from the drop-down.
Choose Source Type as a “User”.
Select a value from the drop-down which needs to fetch in the result & then “Save”.
(D) Local Storage Key:
By using the Local Storage Key, the result is fetched by the value which has been added under the Local Storage Key. But, have to make sure that the value which we are adding is from the Local storage value.
Steps to do:
Click on “Filter”
Select the [+] icon to create New Condition.
Select an appropriate “Field & Operator” from the drop-down.
Choose Source Type as a “Local Storage Key”.
Open the Inspect by right-clicking on the respected object’s list view.
Find the “Local Storage” from the Application tab.
Paste in the value that needs to fetch in the result & then “Save”.
Filter Field:
By using the Filter field we can easily find any record by using multiple filters.
Select fields which would be in filter fields. The fields which have been added in filter fields will show on top of the object’s list view.
