Notifications
Announcements
No record found.
Hi
Please let me know the difference between Virtual fields and Computed columns in Data entity.
Which one recommended to use?
Hi Arpan,
The difference is explained in the documentation: docs.microsoft.com/.../data-entity-computed-columns-virtual-fields
One is using x++ coding and the other is SQL based.
SQL based computed columns are in general faster. If you use e.g. the postLoad() method for virtual fields, it will be a row-by-row execution which will slow down performance tremendously. SO, if possible go for the computed columns.
Thanks Andre
For example- If I want to return "Item name" that i can do with both computed field or Virtual field.
We need to set property in string field -
In String unmapped field 》 property 》 isComputed = Yes or No
Based on IsComputed = Yes or No ,its executed in SQL or X++
For performance respective, computed field recommended to use because its executed in SQL server.
Is it correct?
This is a correct summary of the documentation and your understanding. If you expect a lot of records to be handled with your entity, the for sure try to go for the computed column.
If it is about a group table with e.g. expected max 25 records, then you can choose to use virtual fields when it would be easier to achieve it in this way.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 503 Most Valuable Professional
André Arnaud de Cal... 434 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
