Home > Forum > Known bugs > Column in 'Usage' eventho its not

Column in 'Usage' eventho its not

There is a column (Co_Id) in an item list that states that it is used in an replace item list action.
However the Action is not using this column.
See the pictures in the attachments.

For more information, as far as i know the replace item list used an action template in the template settings.
The Template was changed so that it does not include the "Co_Id" column anymore. The actions that used the form template also reflect the change when opening the configuration, yet the column still states that is being used there.
Interestingly the Column is not directly used by the Action Template only in the action that used it as template.

In reply to: Almin

We already cleared the problem, however should is this behaviour intended ? Secondly if i press the button it would also add the columns that i do not want to fill with sql and then i would have to manually remove them.

Hi,
Clicking the Refresh button synchronises the columns in the item list with the underlying data source/SQL query. This means that any columns returned by the query will be added automatically.

One practical challenge is that a single data source can be reused in multiple places and often contains more columns than are required for a specific item list. In such cases, it is not always feasible to reduce the number of columns in the shared data source or SQL query directly.

My recommendation in this scenario is as follows:
- If possible, adjust the SQL query (or view) for this specific use case so that it only returns the columns that are required for the item list.
- Use the Refresh button once to import all columns, then manually remove the unnecessary ones and avoid further refreshes unless the data source structure changes.

Best regards
Maryna