Hi all,
I have an entity named "GED" whitch have an attribute "new_levelged", and every user of the system has its new_levelged too,
I want create a view that displays only GED records whitch have GED.new_levelged <= systemuser.new_levelged,
How to do that in Dynamics CRM 2016 ? Can I do this with fetchxml ?
Thank you all :)
*This post is locked for comments
Hi Soumia,
you can't compare fields in the fetchXml, so the short answer is, likely, "NO".. at least not with what CRM gives you out of the box.
If you don't mind doing some plugin development, you might use a pre-retrievemultiple plugin:
- First, you would create a view where you would use some generic condition: new_levelged <= -100
- In the plugin, you would replace that -100 with the actual value you'll get from the current user record
There is an example of pre-retrieve multiple plugin here:
nishantrana.me/.../plugin-on-retrieve-multiple-in-crm-2015
Once you have access to the "QueryExpression", you can look at the conditions in that query and modify them
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
