News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Data entity view metho...

Finance | Project Operations, Human Resources, ...

Suggested answer

Data entity view method not returning a value

(0) Share

Report

Report

Posted on by j999888777

64

I have a custom data entity, and I want to create a new field containing a product's height in centimeters (data entity will contain both inches and cm). I created a data entity view method called "displayEachHeightCm"). This view returns a conversion if I hardcode something into the UnitOfMeasureConverter method (ex.,UnitOfMeasureConverter::convert( 12345), ), but when I try to pass the current item (gathered from SysComputedColumn::returnfeidl), displayEachHeightCm always returns 0.

Anyone have suggestions on what I'm missing to pass the right value in into the converter?

All responses Img

All responses (2)

Answers Img

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Data entity view method not returning a value

Hi,

Is this question related to D365FO?

Best regards,

Ludwig
Suggested answer

Martin Dráb 230,214 Most Valuable Professional on at

Like (0)

Report

RE: Data entity view method not returning a value

This is a common mistake that we've discussed here many times.

Your understanding of computed columns isn't correct. A computed column method isn't used to return a value; it returns a piece of T-SQL code for the calculation. The method is executed on database synchronization (when the underlying view is written to database) and the piece of T-SQL code is inserted to the view definition.

If you want to use computed columns, your first step should be preparing SQL code that you want to generate. You obviously can't use X++ classes (such as UnitOfMeasureConverter) in SQL, therefore you'd have to rewrite the logic.

If you want to use X++, you can use a virtual field (calculated in postLoad() method). Virtual fields are slower, you can't use them in DB queries etc., but this is their benefit.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans