Skip to main content
Answer

Why is a field of type 'expression' defined in the datamodel section of SF?

  • February 3, 2021
  • 1 reply
  • 45 views

As in subject: since expression fields are not implemented on the database, why are they defined in the datamodel section of the SF, instead of in the subject section?

Best answer by Mark Jongeling

Hey Boudewijn,

The creation of columns is now centralized in the Data model. Since expression fields are part of the data model and are very similar to 'normal’ columns, it is handy to put them together. It is also possible to create references between tables by using expression fields. 

If these expression fields would be instead created at Subjects, it would cause us to have two places for Columns to be created. Besides that, I think the reference aspect would then be utilized less.

 

This topic has been closed for replies.

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • Answer
  • February 4, 2021

Hey Boudewijn,

The creation of columns is now centralized in the Data model. Since expression fields are part of the data model and are very similar to 'normal’ columns, it is handy to put them together. It is also possible to create references between tables by using expression fields. 

If these expression fields would be instead created at Subjects, it would cause us to have two places for Columns to be created. Besides that, I think the reference aspect would then be utilized less.