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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 722
André Arnaud de Cal... 605 Super User 2026 Season 1
Subra 547
