Skip to main content

Where Clause Examples

  • semantic_search_text='simon''s term'
  • text='customer -payment' within ('Name', 'Physical Name')
  • ("Endorsed By" != me OR "Certified By"='Administrator') AND "Warned By" NOT EXISTS
  • (customer_attr1 NOT EXISTS) AND (custom_attr2 != -200)
  • (("Updated Date" BETWEEN '1990-01-01' AND '1991-01-01') AND ("Updated Date" NOT BETWEEN '1990-10-01' AND '1992-01-02'))
  • ExpandedMembersOfRole('Workflow Editor') = ANY (ME, 'John')
  • "Updated Date"=YESTERDAY OR "Updated Date"=LAST 5 HOURS
  • "Object Type" = 'Database.Table' AND Children.Name CONTAINS 'ssn'

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!