Hi everyone,
i need to show only the first record in a custom view. The idea is when the record change the state (custom field), for example from open to closed, the view should show the next one.
Is there any way to do this?
Thank for reading.
Hi Tomas.A,
You can use top 1 in your fetchxml.
Tip #738: Use top in fetchxml | Power Platform & Dynamics CRM Tip Of The Day
Unfortunately, you can't specify it for the views just like that, but you might use FetchXML Builder, which is one tool of XrmToolbox
Download XRM ToolBox. https://www.xrmtoolbox.com/
Or you might probably just add your entity/view to a new solution, export it, update the query in the customizations.xml file, and import it back.
Firstly, you need create a system view that is sorted by createdon aescending and then publish the entity, the query will return multiple records, and the earliest recently created one will be at the top.
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...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (