Announcements
Hi
We are trying to customize CRM for a first come, first serve basis.
We are planning to customize a view and use the View Designer available with XRM Toolkit for creating a custom filter.
We would like to return the top record for each account and display in the view.
We are planning to only show the last application for each account in the view.
Our XML would be formatted as follows - I just need to determine how to pass the value for each account.
<fetch top="1" version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="new_application"> <attribute name="new_applicationid" /> <attribute name="new_applicationname" /> <attribute name="createdon" /> <order attribute="new_applicationname" descending="false" /> <filter type="and"> <condition attribute="new_accountid" operator="eq" /> </filter> </entity> </fetch>
I would really appreciate any assistance.
Thanks
Regards
Tony
North52 Quick Tile functionality would allow this (note commercial solution) - you could create a tile which showed the last application on the account form, the use can see summary details in the tile and click through - see the Next Opportunity tile in the image below (note you can have 1 or more tiles, it's not fixed to six like the example below:
Find out more here: https://www.north52.com/apps/quick-tile/
Cheers,
Bruce
First off, its "XrmToolBox". I know what you mean (the free tool that is just awesome) but there is a "Xrm Toolkit" which is a paid add-on for Visual Studio. Glad we got that cleared up. :)
Once approach that is a bit different is to write a SSRS report, you would a lot more flexibility in creating a "view" and use the FetchXML parameters. You could display exactly what you are looking for. You would also be able to create a "drill down" that would allow users to drill back to the D365 record.
You could surface the report on a dashboard via an IFrame. The downside is that you would need to figure out how to write an SSRS report (its not that hard... but some investment in learning would need to happen), the other downside is that it may take a few seconds to render.
Just a thought.
Cheers
Nick
Hi,
One possible option could be to use custom filter for view is to have a plugin and change view output based on your custom filter, if possible you can query your account based on some fields.
Hi,
I am afraid this may not be possible in a view.
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... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156