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.
Its working fine thank you GirishS
Yes, you need to add DefaultDimensionView as a DataSource to your form and add link between CustTrans and DefaultDimensionView in OnInitialize event handler.
Also, if it's a custom form you can directly add the link code in init method of the DefaultDimensionView datasource.
if it's a standard form use event handler.
Thanks,
Girish S.
Sorry but i m lost now,
Should i still use a View or just adding DefaultDimensioView as datasource on my form and put the code :
' DefaultDimensionView_ds.queryBuildDataSource().addLink(fieldnum(CustTrans, defaultDimenions),
fieldnum(DefaultDimensionView, DefaultDimenion));'
on the onInitialized event on this new datasource ?
Try like below. It should be on DefaultDimensioView onInialized DataSource method not on execute Query method.
DefaultDimensionView_ds.queryBuildDataSource().addLink(fieldnum(CustTrans, defaultDimenions), fieldnum(DefaultDimensionView, DefaultDimenion));
Thanks,
Girish S.
So the first datasource to select is defaultdimensionview and then add join datasource Custtrans
Cause if i do the reverse i didnt get the same relation
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.
Thanks,
Girish S.
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.
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.
Thanks,
Girish S.
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.
Thank you guys i will try that
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156