Microsoft Dynamics AX (Archived)

ax 2009 display method in grid only show first record

(0) Share

Report

Posted on by Ganriver1

1,559

Hi Friends,

I create a display method in SalesTable to display customer name. Here is code:

But, only the first record show the name in grid, if you sort it, it still show in first record but different name. Where did I miss something?

Regards,

River

display CustName custName()
{
    CustTable custTable;
    ;
    select Name from custTable where custTable.AccountNum == this.CustAccount;

    return custTable.Name;
}

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

This display method needs to be created at table level

Please let us know where you have created the display method

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

It's on SalesTable.

Was this reply helpful? Yes No
naveen singh 780 on at

Like (0)

Report

Hi Ganriver,

There is already a method exist in the salesTable name CustTable_CustAccount().Use this method to return the customer name.

display CustName custName()

{

return this.CustTable_CustAccount().Name;

}

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

I used this one, it's the same thing. Just show the name for the first record in grid.

Was this reply helpful? Yes No
Suggested answer

WPAK on at

Like (0)

Report

Hi there,

is the display mentod created on the Table element SalesTable or on the SalesTable DataSource on the form?

If it's created as method on the Datasource in the forum you will need to pass the buffer.

If the method is placed on the table that isn't necessary.

I would also advise adding the firstonly keyword. It won't change the result in this situation, but it will make sure only the first record is found and not multiple. It can only find one record in this situation, since AccountNum is unique, but no need to try and find multiple

display CustName custName(SalesTable _salesTable)

{

CustTable custTable;

;

select firstonly Name from custTable where custTable.AccountNum == _salesTable.CustAccount;

return custTable.Name;

}

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

It's on the SalesTable table. Put 'firstonly' makes no difference.

See pic. Also, the first record is blank in beginning, only when you click on it, it shows 'Name'

Was this reply helpful? Yes No
Verified answer

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

Like (4)

Report

Your display method is on SalesTable. The SalesTable data source is delayed-linked to the active sales line, therefore you simply don't have more than one SalesTable record at any time.

If it's possible (taking into account existing logic of the form), change the delayed link to inner join. If it isn't, either add one more SalesTable datasource (this one inner-joined) or write the display method on SalesLine (but I wouldn't use the last option).

Was this reply helpful? Yes No
Ganriver1 1,559 on at

Like (0)

Report

Thanks Martin,

That's it, it solved problem when changed to inner join.

But, another problem is you can't sort 'Name' by clicking header.

Is this particular for 'display method'?

Was this reply helpful? Yes No
Anton Venter 20,345 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

you cannot sort on display methods or filter on them.

Was this reply helpful? Yes No
Archie 457 on at

Like (0)

Report

Awesome Martin... :) This is such a simple thing, yet makes a great difference in o/p. I guess this is what it means to be an expert..Thanks. Please continue to enlighten us with your knowledge...

Was this reply helpful? Yes No