If data is to be accepted after filtering, you can formulate a statement here. You can
then assign the query result as usual in the field assignment to a
target data field.
In the upper area of the dialog, enter the Name of
the SQL query. In the lower area, you will find the Query field.
Database tables, fields, and the source fields for the comparison can
be selected in the three columns above the query field. If you click on
the arrow button below a column, the element
highlighted in the column will be inserted into the Query field.
When formulating the query, please take care to use the correct syntax
depending on the database.
In the Tables for query in target column, you will
find the Search tab.
Here you have the ability to search specifically for tables. To do so,
enter the search term into the Filter field and
then click on Search.
arrow button below a column, the element
highlighted in the column will be inserted into the Query field.
When formulating the query, please take care to use the correct syntax
depending on the database.
Search.