Reference Documents (New)
      Back to home
      1. Knowledge Base
      2. Data Catalog
      3. 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.