Expression Builder

The Expression Builder is used in the Data enrichment tasks and Work queue settings in the Administration module. You can use it to create SQL expression to access database.

The custom Functions list and Fields list are provided to compose the SQL expression.

The Fields list is a searchable list of all fields in the database tables. Each field has an Add action that can be used to append the field into the expression editor.

The Functions list is a searchable list of all functions. Each function has an 'Add' action that can be used to append the function into the expression editor.