Before using the data table custom field, configure it as described on the Data Table Configuration page.
For this example we will use used a dynamic SQL script as a data source to retrieve all data from a product table based on the value of another custom field. So the configuration for our custom field will look looks like this:
where {customfield_10001} represents a free text custom field which will be used for filtering the product name.
After the field is configured, when we you view, create, edit an issue, or transition it, the data table custom field is populated with the values retrieved from running the sql query with the given parameter taken from issue.
...
Every time the parameter custom field changes, the query is re-executed and the grid displays the new updated results accordingly. Issue standard fields can also be used as dynamic parameters for the query. For more details check out see the Dynamic Query (SQL) page.
If the field would be is configured without the dynamic parameter in the sql (without the where WHERE clause) it would always retrieve all results from the table, as shown below:
...