Show only first record in a view

(0) Share

Report

Posted on by Tomas.A

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.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No