Conditional Search 
Conditional search represented by the eight dots icon, is available next to the search field. This feature allows for advanced and refined searches based on specific conditions or criteria. By utilizing conditional search, users can further customize their search queries and filter the results to find precisely what they are looking for. It helps to fetch fine-grained search results by excluding/including keywords in search results, using conditional operators.
OvalEdge supports eight different search options listed below:
|
Selection Condition |
Function |
|
Contains |
To include objects in the search that contain at least one occurrence of the value entered. For example, if you search for "book," it will include all objects that contain the word "book" anywhere within them. |
|
Doesn’t Contain |
To exclude objects from the search for the value entered. For instance, if you search for "book," it will exclude all objects that contain the word "book." |
|
Equals |
To search objects that have an exact match to the value entered. If there are three data objects in the catalog related to fruits, one with the name "Apple," another with the name "Red Delicious Apple," and the third with the name "Banana," only the first object will be included in the search results when you use the "Equals" filter with the value "Apple." |
|
Doesn’t Equal |
To exclude objects from the search that match the value entered. For Example, if you're searching for data related to cars, but you want to exclude any results that have the make and model "Toyota Camry." In this case, you would use the "Doesn't Equal" filter and enter "Toyota Camry" as the value. This will exclude any objects that have the exact value "Toyota Camry" in them, even if they contain the words "car" or "Toyota" separately. |
|
Empty |
To include objects in the search results that contain null values. For example, if you're searching for data related to customers and you want to find all the objects that do not have an email address associated with them, you would use the "Empty" filter on the email address field. This will include only objects that have null values in the email address field, indicating that there is no email address associated with those customers. |
|
Is not Empty |
To search objects that do not contain null values. For example, if you're searching for data related to customers and you want to find all the objects that have an email address associated with them, you would use the "Is not Empty" filter on the email address field. This will include only objects that have a value stored in the email address field, indicating that there is an email address associated with those customers. |
|
Ends With |
To include objects in the search that end with a specific value entered in the field. For example, if you're searching for data related to products and you want to find all the objects that have a product code that ends with "123," use the "Ends With" filter and enter "123" as the value. This will include only objects that have a product code ending with "123" in the search results. |
|
Starts With |
To include objects in the search that start with a specific value entered in the field. For example, if you're searching for data related to products and you want to find all the objects that have a product code that starts with "123," use the ‘Starts With" filter and enter "123" as the value. This will include only objects that have a product code starting with "123" in the search results. |