Query Fields:

Queryfields are the equivalent to the columns in a sql select statement. If no field is prodived, the query is generated like SELECT * FROM TABLE.

 

Parameters:

  • Title
  • Database Table
  • ColumnName
  • SQL Function
  • Is key?

Table

The table defines the table where the data is fetched. This could be a view, DUAL, a table or a renamed table.  

Title

This is used only for list.

Column

Used if no SQL Function is present. Combination of Table and Column represents the selected field.

SQL Function

Here you could put in sql code

Be careful, only use renaming “xyz as field” when query is no datatable query

Is key:

Is the column unique? Convinient is to have one column called id, which is the key. This column is used for linking and joining data.