Microsoft Dynamics AX (Archived)

How to filter display method field in ax 2012

(0) Share

Report

Posted on by Mohammad Raziq Ali

2,486

I am using display method field in form which I want to filter by pressing CTRL+G or some other approach.

Thanks,

Raziq

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Anton Venter 20,345 Super User 2025 Season 2 on at

Like (0)

Report

Hi Raziq, it is not possible to filter or sort with display methods.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (2)

Report

As Anton said it's not possible, but if the method is not too complex, you can maybe add the required tables as datasource. Otherwise you have to create a view and make your display method a computed column. You then can add the view as datasource and drag the computed column into the form. Then you will be able to filter it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jens,

You said that "you have to create a view and make your display method a computed column " but problem is that computed column must be static and server method ,and display can not static ,then what we do??.

if you have any example then please provide .

Was this reply helpful? Yes No
Suggested answer

Faqruddin 1,883 on at

Like (0)

Report

Check this post

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Faqru Shaik ,

Thanks for your response ,its working .

But i want to try that approach.

Please help .

Was this reply helpful? Yes No
Suggested answer

Faqruddin 1,883 on at

Like (0)

Report

Hi,

Have a look this example

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes,

In this example the method must be statics for computed column . but i m using display method .as per my knowledge display methods can't be static . so how to apply on this approach. if it is possible then provide me solution .

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report

Regarding "method must be statics for computed column" and "as per my knowledge display methods can't be static":

That's both correct and it's no contradiction at all.

You have either a computed column (a static method generating a piece of SQL code inserted into a view) or you have a display method. These are two completely separate things; if you want to use a computed column, what is syntax for some unrelated thing (such as a display method) is irrelevant.

Either you use a display method and you follow rules for display methods. Or you're making a computed column and you follow rules for computed columns. Don't try to mix them; it doesn't make sense.

Was this reply helpful? Yes No
Dang Vo 31 on at

Like (0)

Report

Collect all data to a view and change the data source of form to this view. You can filter like Ctr+G

Was this reply helpful? Yes No