Reference Documents (New)

Search using the Conditional Filter or the 8-dots option

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.