-
Notifications
You must be signed in to change notification settings - Fork 3
QuerySchema
David Lidström edited this page Oct 27, 2017
·
4 revisions
If you are familiar with CAML you can find information about the camlsql-js implementation of the Query Schema elements in the pages below.
Query Schema (July 15, 2011). Microsoft Developer Network - https://msdn.microsoft.com/EN-US/library/ms467521.aspx [Visited 2017-10-26]
-
And Element -
WHERE Field1 = ? AND Field2 = ?,['some', 'value'] -
BeginsWith Element -
WHERE Field1 LIKE ?,['prefix%'] - Contains Element - TBD
- DateRangesOverlap Element - TBD
-
Eq Element -
WHERE Field1 = ?,[5] - FieldRef Element - TBD Partially implemented
-
Geq Element -
WHERE Field1 >= ?,[15] - GroupBy Element - TBD
-
Gt Element -
WHERE Field1 > ?,[2017] - In Element - TBD
- Includes Element - TBD
-
IsNotNull Element -
WHERE Field1 IS NOT NULL -
IsNull Element -
WHERE Field1 IS NULL -
LeqElement -
WHERE Field1 <= ?,[2017] - ListProperty Element - TBD
-
Lt Element -
WHERE Field1 < ?,[2017] - Membership Element - TBD
- Month Element - TBD
-
Neq Element-
WHERE Field1 <> ?,[2017] - NotIncludes Element - TBD
- Now Element - TBD
-
Or Element -
WHERE Field1 = ? OR Field2 = ?,['some', 15] - OrderBy Element -
- Today Element - TBD
- Membership Element - TBD