Share
ReportHi,
is there any possibility or any workaround idea to make filter the display method fields in grid view.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
is there any possibility or any workaround idea to make filter the display method fields in grid view.
*This post is locked for comments
I already replied to the same question on another forum. For completeness, let me copy my reply here as well:
Using X++ method in SQL WHERE conditions isn't possible.
Workarounds include filtering by the field(s) used by the method, using joins instead of display methods, creating computed columns instead of a display methods and maintaining persistent fields instead of display methods. Each of them has its pros and cons; what you should choose depends on your particular situation.
This varies from scenario to scenario. e.g. if you want to disply customer name on customer master, a way can be using display method showing you name from DirPartyTable. second way can be making join of CstTable with DirPartyTable.
your display method is bringing data using some logic. if you can create a view using similar logic, you can join your base table with view. if there is no complex logic in displayMethod you can create direct join with table from where data is being displayed. All depends upon how is your display method and how you are displaying data using display method.
Hi Sohaib,
Thanks for your reply. Can you send me an example of the above done for similar kind of things.
Hi,
As a workaround, you could export data to excel and apply the required filters.
Probably you can use Dynamics AX Excel Add-In
(community.dynamics.com/.../using-the-dynamics-ax-excel-add-in)
Thanks,
Chaitanya Golla
The short and rational answer is 'No'.
as alternative, you can think to replace the display method field with extra join to table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (