Announcements
No record found.
Hi,
I red that i couldn't get a column header filter on a field made by a display method.My question is how could i get that ?How could i get the same result but the possibility to use column header filter ? What is the best way ?
Thank you.
One way is to create a view using the same ds like how you created select statement.
Second is to use fields added via form ds. These both ways will give you filter option.
Could i ask how to create a view ? and why a view is useful ?
Hi Mack Nate,
View is a group of tables with relation which displays data from multiple tables.
So if you need to filter the display method as Bharani told you need to convert that display method to view and add that view as a DataSource to the form, then only you will be able to filter the records.
Thanks,
Girish S.
Please check the below url for creating it.
dynamics365ax2012.blogspot.com/.../how-to-create-view-in-dynamics-365.html
Thank you guys i will try that
Hi guys Bharani Preetham Peraka , GirishS
I dont see how i could use my display method on a view ?
I'm creating my view using CustTrans Table as datasource.
The field i need to display is the 'DefaultDimension'
How i could retrieve the same result by using my view ?Should i add this method without the 'display' keyword like a view method ?Regards.
You can join CustTrans table with DefaultDimensionView. DefaultDimensionView contains field named "Name" where you can filter by Departments and field named "Display value" which will gives you the dimension value.
Should i add something more than that relation to reach my goal ? Computed Column ? New method ?
Or this relation will be enough ?Sorry to bother, i'm newbie and that's the first time i m handling views and this case.
No, not needed. You need to set the relation between the CustTrans and DefaultDimensionView in the OnQueryExecuting method of the DefaultDimensionView datasource.
Relation will be DefaultDimensionView.DefaultDimension == CustTrans.DefaultDimension.
So the first datasource to select is defaultdimensionview and then add join datasource CusttransCause if i do the reverse i didnt get the same relation
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 429 Most Valuable Professional
CU10121822-0 366
André Arnaud de Cal... 360 Super User 2026 Season 2
