Open
Description
Is your feature request related to a problem? Please describe.
When using a dynamic query that pivots the data to make columns, the LC table does not regenerate the columns.
Instead it adds additinal columns but does not remove them.
Describe the solution you'd like
Ideally, a single column type of 'dynamic' could be used for dynamic queries.
This single column would always be the last column, and is configured to repeat the data type for every additional column in data[] beyond the predefined columns. All prior columns remain static, only the last column can be dynamic.
Each time the dynamic query is run all 'dynamic' columns are removed and the 'dynamic' column(s) regenerated.
Something like this...
