...
If the field would be configured without the dynamic parameter in the sql (without the where clause) it would always retrieve all results from the table, as shown below:
You can change the table headers by specifying columns alias in the sql query. For our example, you can change the sql query to display the columns names as Id, Name and Description. You can also specify an order by clause, to display the data in the table grid ordered by the desired column:
| Code Block |
|---|
SELECT P_NAME AS Name, P_DESCR AS Description, P_ID AS Id FROM PRODUCT ORDER BY P_NAME |
After saving the configuration with the modified sql query, the data table custom field will display our data like this:
