web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to add virtual and...

Microsoft Dynamics AX (Archived)

how to add virtual and Computed columns in Data Entity in D365FO

(0) Share

Report

Report

Posted on by @rp@n

30

Hi All,

Can you please let me know how to add virtual and Computed columns in Data Entity ?

Please give me more shed on this.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

@rp@n 30 on at

Like (0)

Report

Thanks Sukrut

I will go through.

Suppose if we add Computed OR Virtual columns in Data entity. Is't appeared in SQL Server also?

Please give me more shed on this.

Thanks!

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Sukrut

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,884 Most Valuable Professional on at

Like (0)

Report

You can simply look into the view to find the answer by yourself, if you don't understand the documentation.

Computed columns generate pieces of T-SQL code that are injected to views in database. Virtual fields, on the other hand, are handled in X++, not in database views.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Martin

That means Computed columns are present in database not Virtual columns.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans