Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

How to filter display method field in ax 2012

Posted on by 2,427

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

Thanks,

Raziq

  • Dang Vo Profile Picture
    Dang Vo 31 on at
    RE: How to filter display method field in ax 2012

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

  • Martin Dráb Profile Picture
    Martin Dráb 224,528 Super User on at
    RE: How to filter display method field in ax 2012

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to filter display method field in ax 2012

    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 .

  • Suggested answer
    Faqruddin Profile Picture
    Faqruddin 1,844 on at
    RE: How to filter display method field in ax 2012

    Hi,

    Have a look this example

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to filter display method field in ax 2012

    Hi Faqru Shaik ,

    Thanks for your response ,its working .

    But  i want to try that approach.

    Please help .

  • Suggested answer
    Faqruddin Profile Picture
    Faqruddin 1,844 on at
    RE: How to filter display method field in ax 2012

    Check this post

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to filter display method field in ax 2012

    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  .  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to filter display method field in ax 2012

    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.

  • Suggested answer
    Anton Venter Profile Picture
    Anton Venter 5,024 Super User on at
    RE: How to filter display method field in ax 2012

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

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans