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