Examples of simple queries

Here are some 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 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’)