Usage of Server Query Expressions in Lookup Queries

Note that the Server Query option is also available in source or target lookup queries on ServiceNow instances, allowing the use of native ServiceNow query expressions to be used.  The same syntax and restrictions apply as for standard filter queries.

For Service Now lookups ONLY, temporary variables and current record values can be embedded in the query string.

This is an example of a current record value, #number#,  being embedded:

@@QRY('task.number=#number#')

This an example of a temporary variable' #!INCIDENT_NO!# being embedded:

@@QRY('task.number=#!INCIDENT_NO!#')

These embedded variables will be replaced with values at execution time before the query is executed against each record.

Related Articles

Using the Server Query option

Usage of Lookup Queries when Source Server Type is ServiceNow