How do I filter views using both "AND" and "OR" operator?

How do I filter views using both "AND" and "OR" operator?

An example of filtering views using both "AND" and "OR" operator is given below:

The following Criteria specified in a list view named "Check View", fetches records whose Date_field is not empty AND Name field contains "a" OR Name field starts with "bell"

list "Check View"
  {
  show all rows from Check [((Date_Field is not null && Name.contains("a")) || Name.startsWith("bell"))]
  (
  Date_Field as "Date Field"
  Name
  )
  filters
  (
  Date_Field
  )
  }

    • Related Articles

    • Job custom views

      Jobs are grouped and displayed under different job views. Users can utilize the set of default views or create their own custom views. Default Views There are three default views supported by Orchestly. To view the default view: Navigate to ...

    • Managing List Views

      A List View is grouping of records based on a defined set of criteria. List Views are beneficial for displaying customer specific data according to your business requirements. For example, you may be interested in following-up on the candidates ...

    • Manage List Views

      A List View is grouping of records based on a defined set of criteria. List Views are beneficial for displaying specific data according to your business requirements. For example, you may be interested to review overdue tasks or you may want to ...

    • Managing List Views

      A List View is grouping of records based on a defined set of criteria. List Views are beneficial for displaying customer specific data according to your business requirements. For example, you may be interested in following-up on the leads created ...

    • How do I Filter Views based on Date Criteria?

      Show records that expires in the next seven days You can use the following criteria in your view to fetch records ending in the next 7 days, based on the Expiry date in the form. In the sample code given below, Expiry is the name of the date field in ...