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.