DQL syntax

DQL can be executed in the LotusScript® or Java™ Query method on the (Notes®) Database object or the domino-db node.js API.

Using [ and ] to denote option tokens, the syntax of DQL is:

Term [Boolean Term [ Boolean Term ...]]

where the syntax for Term and Boolean is described in the following table.

Note: Spaces are required between Identifiers, Operators, and Values.

Table 1. DQL Term and Boolean syntax
Element	Element	Element	Value
`Term`
	`[Identifier]`
		`SummaryField \| ‘View or folder name’.Columnname \| @function`
			`SummaryField` is the name of any field stored in the summary portion of any document in a Domino® database.
			`View or folder name` is the name, or an alias, of any view or folder created in a Domino® database.
			`Columnname` is the programmatic name of any primary sorted column in the view or folder specified in `View or folder name`.
			`@function` is @all \| @ModifiedInThisFile \|@DocumentUniqueID \| @Created
	`Operator`		= \| > \| >= \| < \| <= \| in [all]
	`[Value]`	`Quoted string value` ’ \| @dt(‘ `datetime value` ’) \| `number` \| ( `in value list` )
			`Quoted string value` is any textual value desired to be found in a field or view column specified
			`datetime value` is an ISO8601-compliant value specified in GMT or Zulu time
			`number` is a floating point number, with or without decimal point, including scientific notation
			`in value list` is ‘ `value 1’` [ `,’value2’ ...` ]
`Boolean`			and \| or \| and not \| or not