Retrieve the last record in an entity

(0) Share

Report

Posted on by Community Member

Hi experts ,
I am writing a C# plugin and I want to access CRM database to retrieve the last record in an customized entity , How could I do that ?

In other words I want to get the same result of this query but using C#
SELECT TOP 1 * FROM MyCustomEntityName ORDER By CreatedOn DESC

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mihir Maruti Kadam 702 on at

Like (0)

Report

This is simple fetchXML generated using Advanced Find. Just add the count to 1.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" count="1">

<entity name="account">

<attribute name="name" />

<attribute name="primarycontactid" />

<attribute name="telephone1" />

<attribute name="accountid" />

<attribute name="createdon" />

<order attribute="createdon" descending="true" />

</entity>

</fetch>

You can refer this link to execute fetchXML in c# plugin

msdn.microsoft.com/.../gg328117.aspx

Was this reply helpful? Yes No
Suggested answer

Ivan Ficko 1,380 on at

Like (2)

Report
var qe = new QueryExpression("MyCustomEntityName"); qe.ColumnSet = new ColumnSet(true); qe.AddOrder("createdon",OrderType.Descending); qe.TopCount = 1; var entity = service.RetrieveMultiple(qe).Entities.FirstOrDefault();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ivan ,

thanks for your quick response which I really appreciate

when I run your attached commend and then I checked the ID for the resulted entity it gives me wrong ID, and when I tried that several times it was giving me different id values and non of these IDs exist in my database

Was this reply helpful? Yes No
ashlega 34,477 on at

Like (0)

Report

Hi Martina,

what kind of plugins is that? Is it registered on the post-create of the same entity? If yes, you may be getting the id of the entity being created every time (might want to move it to the pre-create, for example)

Was this reply helpful? Yes No