Examples of simple queries

Find all documents with order numbers between 146751 and 150111, including the number 150111:

order_no > 146751 and order_no <= 150111

Find all documents that have any one of the four values specified in the sales person field:

sales_person in (‘Chad Keighley’, ‘Jeff Chantel’, ‘Louis Cawlfield’, ‘Mariel Nathanson’)

Find all documents that in the sales_person field have the word ‘Chad’, a word beginning with ‘Chant’ or a word beginning with ‘C’, having any two characters following and ending with ‘field’:

sales_person contains (‘Chad’, ‘Chant*’, ‘C??lfield’)

Find all documents originating after 10 October 2018 at 10:00.00 EST:

date_origin > @dt(‘2018-10-10T10:00:00+0500’)

Using the Orders view, find documents with a value of ‘Phone’ in the order_type column:

‘Orders’.order_type = ‘Phone’

Find documents in any named views and folders:

in (‘Orders’, ’Special orders folder 1’, ‘Old_orders 2’)

Find documents in any named document collections, views, and folders:

in ('TrudisDocs', ‘Orders’, ’Special orders folder 1’, ‘Old_orders 2’)