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 – please let us know!