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.
- Database Table
- SQL Function
- Is key?
The table defines the table where the data is fetched. This could be a view, DUAL, a table or a renamed table.
This is used only for list.
Used if no SQL Function is present. Combination of Table and Column represents the selected field.
Here you could put in sql code
Be careful, only use renaming “xyz as field” when query is no datatable query
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.