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
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)
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
Share
Report
All responses (
Answers (
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();
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
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156