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.

Custom Query add

This will bring up the Custom Query Editor frame.

Custom Query empty

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.

Custom Query some query

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.

Last modified: Sep 13, 2021

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment