This topic contains examples of basic range filter queries.

The first query example uses the > operator to return any record that has an author_id property whose value is greater than 100.

collection()/record
[
	author_id > 100
]

The next query example uses the >= operator to return Book records whose book_id property value is less than or equal to 99. The example also shows the use of the and operator.

collection()/record
[
	Recordtype = "book" 
	and
	book_id <= 99
]

The last query example shows an RRN query that uses a range filter expression in its predicate. Based on a relationship filter applied to the Book and Author records, the query returns Book records (which have the book_authorref property) of authors whose books have been edited by an editor whose ID is less than or equal to 12.

collection()/record
[
	book_authorref = collection()/record
	[
		author_editorref <= 12
	]
/author_id
]

Copyright © Legal Notices