Custom Query Tables

What is a Custom Query Table ?

When composing a Data Source, you are not limited to using Tables or Views from your Connection.

You can also add a Custom Query Table : similarly to a SQL View, you write a SQL query and a Table will be created in the currently opened Data Source.

However, this can be more than a simple way to create a custom View, as we will see further in the Using Parameters chapter.

Pre-requisite

In this Chapter, we will edit a Data Source.

To learn how to create or edit a Data Source, see the previous Chapter “Creating and Managing Data Sources”.

In this Chapter, it is assumed that you have created a Data Source and that it is open for edition.