What is wrong with my Computed Column in Data Entity

(0) Share

Report

Posted on by Community Member

Hi all,

Need some advice on my custom Data Entity, whereby it is Build successfully, but when use it to Export, it has error processing message.

Firstly, I create a custom Data Entity with source is Sales Line, then added these computed field :

 public static server str displayLineAmt1()
    {
        
        return SysComputedColumn::multiply(
            SysComputedColumn::returnField(tableStr(M_SOLineEntity), identifierStr(SalesLine), fieldStr(SalesLine, SalesPrice)),
            SysComputedColumn::returnField(tableStr(M_SOLineEntity), identifierStr(SalesLine), fieldStr(SalesLine, SalesQty))
            );

    }

and

 public static server str displayLineAmt2()
    {
        M_SOLineEntity  mSOLine;
        SalesLine   SalesLine;

        select SalesLine where SalesLine.SalesId == mSOLine.SalesOrder && SalesLine.ItemId == mSOLine.ItemId;

        return int2Str(SalesLine.SalesPrice * SalesLine.SalesQty);
    }

My intention of building these 2 similar result is for learning only. For the 1st one, the approach is from Microsoft, but the 2nd one I saw from someone blog.

Also is it true, if we want to export Data Entity with calculated column, we should Skip Staging ? how about Virtual field ?

Thanks,

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

The second method is not correct. Please check the answers in your other question, there we explained the difference between a computed column and a display method.

Was this reply helpful? Yes No
Verified answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

2nd one is the display method and not a method for the computed column, you cannot use that as a computed column.

Was this reply helpful? Yes No
Verified answer

Jeremy_Mounet 170 on at

Like (0)

Report

Hi

The two methods are completely different :

First is a computed column for a View (as explain in the thread community.dynamics.com/.../1081185

This method will calculate an amount for every row of the view.

Second is a static method to calculate an amount in X++. It is a static method so running without any context (no parameters) so I don't understand exactly its result.

What do you want to perform exactly ? Compare virtual field and calculated field in a data entity ? If yes, try to parse standard dataentity through the AOT or Views to compare the two kind of implementation.

It is globally different on the execution (SQL vs X++ execution).

Jérémy.

Was this reply helpful? Yes No
Verified answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

These are two different methods which will use for separate implementations, 1st method is for computed column which should work fine in your case. 2nd method can not be linked to any data entity field as this is a display method and it is recommended to keep display methods at table level but again depends on the implementation.

Are you trying to compare virtual fields with computed columns?

The best explanation is here docs.microsoft.com/.../data-entity-computed-columns-virtual-fields at least I have found it very useful always.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi all,

Yes, understood now.

Anyway for the 2nd method, I get it from this blog :

shyamkannadasan.blogspot.com/.../data-entity-in-ax7-with-computed-and.html

..probably it was meant for something else. I will use the 1st one, as describe from you all.

thanks,

Was this reply helpful? Yes No