3.30 RDBMS Data Sets

A data set based on an RDBMS table is a structured collection of data retrieved from one or more relational tables.

 

Use the menu on the left to select My Project, choose the specific project, and then select Data Sets.
The following table will be displayed, showing all data sets associated with the project:



Add a data set based on RDBMS table(s) by clicking the 'Add Data Set' button:

Fill in the fields: Name, Data Source Name, Description, and Tags.

Data Entity area:

Based on the selected data source, the relevant tables will be displayed. Select the table that will be used as a base for the Data Set:

Friendly name - the user can choose an alias that will be used instead of the file name in the "Selected columns" area in the column "Table". For example:

Additional table(s) can be added by clicking on 'Add Data Entity'. There is an option to Choose join type (left join, inner join) between 2 or more tables. Define the join condition between the tables (more than one condition could be applied):  

Click "Display Code" below the condition to see the SQL query that will be applied:

In the "Selected Columns" section from the right you can choose the columns that will participate in Data Set. Below there is an option to "Add Group By". Clicking it will and a new window will open (Aggregate functions can be used):

You can add filter(s) to the Data Set:

Filters can be added easily and can combine more than one condition for each filter. 

It's possible to use predefined variables for the Data Set. 

 

On the top right side of this window click "Custom Command Filter" - the query will be revealed (will be possible to edit it manually):

In conclusion "Query Builder" mode - quilliup allows to build a complex query without writing the SQL code itself! 

Another option to build a Data Set is by building the query using "Custom SQL" mode:
When "Custom SQL" mode is chosen, a new checkbox “Save Query” appears.

Save Qurey - when checked, if Data Source name changes, a prompt dialog will appear, asking whether you want to save the query to the clipboard.

User can customize his own SQL query and also to use all previously described functionalities. 

Friendly name - the user can choose an alias that will be used instead of the file name in the "Selected columns" area in the column "Table". For example: