You can insert parameter references in the RAQL query of the RAQL Inline operator. They are represented by a colon, followed by the parameter name. If the name contains special characters, they must be enclosed in double quotes.
Parameters are handed over to the RAQL engine as typed values along with the RAQL statement at execution time. RAQL statements are usually passed unchanged to the RAQL engine. If they contain list parameters, they are rewritten to use single value parameters as follows:
A reference of a non-empty list is replaced by a comma-separated list of parameter references, one for each list element. This is useful for populating the values of an IN predicate by a list value.
Example
SELECT * FROM „Stream 1" WHERE column IN (:list)
with 3 elements in the list is rewritten to
SELECT * FROM „Stream 1" WHERE column IN (:"list[1]","list[2]","list[3]")
In this case, "list[1]" etc. are generated names for the individual list elements.
A reference of an empty list is not replaced, but a single NULL value is passed to the RAQL engine.
The last rule provides a valid RAQL statement for an empty list. Note that if the list of values is empty, both predicates IN and NOT-IN return the same result UNKNOWN and not FALSE.