Where in the generation process are calculated columns generated and written to the database?
This question came to me after I saw that you can modify the calculation query at Subjects.
Best answer by Mark Jongeling
View original
Generation process calculated columns
Userlevel 3
+5
- Captain
- 76 replies
Userlevel 7
+21
Hi Dennis,
Yes, Calculated columns are indeed stored on the database and do require an upgrade after changing.
Reason the fields is mutable here is that expression fields are no problem to change.
Userlevel 3
+5
- Captain
- 76 replies
-
13 January 2023
Hi Mark,
That expression fields are modifiable in subjects I understand. However, the column "pallet_price_1_incl_diesel" is not an expression field but a calculated column. Wouldn't it make more sense that this is only modifiable in the data model so that the SF recognizes this as a model change and picks it up with this in the upgrade script?
Userlevel 7
+21
Hey Dennis,
That would indeed be a great solution, but sadly we currently cannot make this query read only only on this screen for a specific Calculation type. That would require some additional model objects just to let the Layout procedure know when to make this query field read only.
An alternative could be that this screen prevents an update of the query in all cases, so no matter which Calculation type is chosen, the query cannot be edited here. I'll discuss this with the team to see what would be a suiting solution.
Userlevel 3
+5
- Captain
- 76 replies
-
13 January 2023
I am curious about the outcome. I especially wanted to make sure I understood the operation of calculated columns correctly.
Userlevel 7
+21
Discussed it a bit, it seems that this was a result of allowing Column configuration changes inside the Subjects screen. As this field is more Data model than GUI, we'll make the query field read only for this screen for the 2023.2 release.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.