Display method value is updated on all records on grid

(3) Share

Report

Posted on by SKO

312

Hello

I am using D365fo. I have a display method on a form data source through extension and used the method on a grid which has fields from two different data sources. My display shows data correctly, but the problem is when a row is highlighted, the value from currently highlighted row on display method field updates the value of all the rows on display method field on the grid.

Here is my method

public display customfield Number(ReqTransCov  _reqTransCov)
{
    FormDataSource ReqTransSettledDS = this.formRun().dataSource("ReqTransSettled");
    ReqTrans reqTransSettled = ReqTransSettledDS.cursor();
    xxxProductAttributes     ProductAttibute;
    if (reqTransSettled.RefType == ReqRefType::ProdLine)
    {
        ItemId  itemId =  ProdTable::find(reqTransSettled.RefId).ItemId;
        select firstonly ProductAttibute
            where ProductAttibute.Product == InventTable::find(ProdTable::find(reqTransSettled.RefId).ItemId).Product;
    }
    else if (reqTransSettled.RefType == ReqRefType::Sales)
    {
        select firstonly ProductAttibute
           where ProductAttibute.Product == InventTable::find (_reqTransCov.ItemId).Product;
    }
    return ProductAttibute.Num;
}

Thanks

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

All responses (2)

Answers (1)

SKO 312 on at

Like (0)

Report

Display method value is updated on all records on grid

Thank you very much for enlightening me.
Verified answer

Martin Dráb 233,896 Most Valuable Professional on at

Like (2)

Report
Display method value is updated on all records on grid

Your method will calculate for each ReqTransCov record, but it uses the same (the currently selected) ReqTrans in all cases. That's very likely not what you wanted, therefore your desing doesn't meet your own requirements.

I'm assuming that ReqTransCov and ReqTransSettled data sources are joined and what you should do is getting ReqTrans from ReqTransCov (though either IssueReqTrans or ReceiptReqTrans relation), instread of taking the currently selected record from ReqTransSettled data source.

By the way, if accessing the currently selected ReqTrans was the right thing to do, you could replace

FormDataSource reqTransSettledDS = this.formRun().dataSource("ReqTransSettled"); ReqTrans reqTransSettled = reqTransSettledDS.cursor();

with mere

reqTransSettled

because there are a few automatically created variables for each data source, such as reqTransSettled with the selected record, reqTransSettled_ds representing the FormDataSource object and so on.

And avoid hard-coding elements names as text. Instead, use functions like formDataSourceStr() to validate the name by the compiler and to include the reference in cross-references.

Community site session details

Display method value is updated on all records on grid

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Display method value is updated on all records on grid

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates