Overview of User-Defined Queries

If the existing capabilities of the expression builder aren't enough, use user-defined queries to retrieve data for use in expressions. User-defined queries are Select SQL queries run directly on your database.

The Administrator creates a table-validated value set that includes a Select SQL query. The administrator then adds this new value set to a lookup that displays in the expression builder menu as a user-defined query.