Creating a Custom Query Table

To do so, open the Data Source where you need to add a Custom Query Table.

From the Connection schema below, click on Add Custom Query.

This will bring up the Custom Query Editor frame.

Write the query in the correct SQL language (see the previous chapter “Language”).

For bufferized Connections, you can use the table names as listed in the schema.

Click OK to create the Custom Query Table. Fix any SQL error if necessary.

Now the Custom Query Table is created in the Data Source currently opened. It can be used like a normal table from the same Connection and, for example, can be used in a Join.