[en] TS002550335 — "Invalid column name" error occurs in Composer
[en] Fixed: Resolved an issue where users cannot edit or delete calculations or tables or open components that are used by view tables.
[en] Now, an error occurs if users attempt to delete a column used by a view table.
[en] Reproduction Steps
[en] 1. Log in to the admin client.
[en] 2. In Composer, add two custom tables.
[en] a. Click 'Add a column' to add more fields to the table and add: ID (text, key), Date (date), and Value (numeric).
[en] 3. Add two calculations. Name them Calc1 and Calc2.
[en] a. On the Data Sources tab, define one of the tables as the data source for each.
[en] b. On the Display Columns tab, define the ID column as the partition for one calculation. Define the Date column as the partition for the second calculation.
[en] c. On the Formulas tab, add "1" as the formula for both calculations.
[en] 5. Add a view table.
[en] a. On the Data Sources tab, define both calculations as data sources.
[en] b. On the Restriction tab, define the restrictions as Calc1.ID = Calc2.ID.
[en] c. On the Display Columns tab, select Date as the display column.
[en] 6. Edit Calc1 to remove the display column.
[en] 7. Try to edit Calc1 again.
[en] The result is an error occurs when users should not be able to remove display columns that are in use by a view table.