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'