How to get count of records of say contact entity using C#

(0) Share

Report

Posted on by Community Member

Hello All,

I was using fetchXML to grab the number of count of Contact entity and I got say 100 records. Now in order to display that in messagebox using C#, can anyone please help me with the code.

I was trying to use -

string fetchXml = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' >

----------

--------

</link-entity>
</entity>
</fetch>";

FetchExpression fetch = new FetchExpression(fetchXml);
EntityCollection results = _service.RetrieveMultiple(fetch);
MessageBox.Show("Count of Records:" + results);

But I know its not correct, please advice me.

*This post is locked for comments

I have the same question (1)

All responses (27)

Answers (2)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Try following:

MessageBox.Show($"Count of Records: {results.Entities.Count}");

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

Hi Suchi,

Try with this -

MessageBox.Show("Count of Records: " + results.Entities.Count);

Was this reply helpful? Yes No
Suggested answer

Anas Rafik 365 on at

Like (1)

Report
Try this

FetchExpression fetch = new FetchExpression(fetchXml); EntityCollection results = _service.RetrieveMultiple(fetch); throw new InvalidPluginExecutionException("Count of Records: "+results.Entities.Count);

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (1)

Report

I have used this in the past for FetchXml Count Aggregate function:

public static int GetRecordCount(string entityName, string attributeName, ConditionExpression expression)

{

int rc = 0;

StringBuilder sb = new StringBuilder();

sb.AppendLine("<fetch distinct='false' mapping='logical' aggregate='true'> ");

sb.AppendLine(" <entity name='" + entityName + "'> ");

sb.AppendLine(" <attribute name='" + attributeName + "' alias='" + attributeName + "_count' aggregate='count'/> ");

sb.AppendLine(" <filter type='and'>" );

if (expression.Values.Count > 1)

{

sb.AppendLine(" <condition attribute='" + expression.AttributeName + "' operator='in'>");

for (int i = 0; i< expression.Values.Count; i++)

{

sb.AppendLine(" <value>" + expression.Values[i].ToString() + "</value>");

}

sb.AppendLine(" </condition>");

}

else

{

sb.AppendLine(" <condition attribute='" + expression.AttributeName + "' operator='eq' value='" + expression.Values[0].ToString() + "' /> ");

}

sb.AppendLine(" <condition attribute='statecode' operator='eq' value='0' /> ");

sb.AppendLine(" </filter> ");

sb.AppendLine(" </entity> ");

sb.AppendLine("</fetch>");

EntityCollection totalCount = OrganizationService.RetrieveMultiple(new FetchExpression(sb.ToString()));

if (totalCount.Entities.Count > 0)

{

foreach (var t in totalCount.Entities)

{

rc = (int)((AliasedValue)t[attributeName + "_count"]).Value;

break;

}

}

return rc;

}

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It throws a Nullreferenceexception just at the line :EntityCollection results = _service.RetrieveMultiple(fetch); I am trying to code this inside button event, can that be the cause?

private void btnUpdate_Click(object sender, EventArgs e)

{

string fetchXml = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' >

<entity name='contact'>-------------

------------------

</link-entity>

</entity>

</fetch>";

FetchExpression fetch = new FetchExpression(fetchXml);

EntityCollection results = _service.RetrieveMultiple(fetch);

throw new InvalidPluginExecutionException("Count of Records: "+results.Entities.Count);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the code, however, I want a messagebox to pop up and show the number of records, and I am unable to place it inside the button event as it wont understand totalcount : - MessageBox.Show($"Count of Records:{totalCount.Entities.Count}"); Can you please be kind enough to advice me...

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (1)

Report

Hello,

Have you created OrganizationService object ?? I think you have created _service object so you need to use that instead (based on your first thread).

EntityCollection totalCount = _service.RetrieveMultiple(new FetchExpression(sb.ToString()));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes Mahen, I figured that out and fixed it and thanlks for your quick reply, but the message box fails to read total count which is stored in public static int GetRecordCount(string entityName, string attributeName, ConditionExpression expression){} and my button_click should pop up the message with the count of record... Can you please help on that !!!

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Please share your complete code here for checking

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here it is : -

private void btnUpdate_Click(object sender, EventArgs e)

{

string fetchXml = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false' >

<entity name='contact'>

<attribute name='fullname' />

<attribute name='ownerid' />

<attribute name='parentcustomerid' />

<attribute name='aac_palno' />

<attribute name='mobilephone' />

<attribute name='jobtitle' />

<attribute name='telephone1' />

<attribute name='address1_country' />

<attribute name='address1_city' />

<attribute name='emailaddress1' />

<attribute name='address1_stateorprovince' />

<attribute name='contactid' />

<order attribute='parentcustomerid' descending='false' />

<order attribute='fullname' descending='false' />

<filter type='and'>

<condition attribute='statecode' operator='eq' value='0' />

</filter>

<link-entity name='account' from='accountid' to='parentcustomerid' visible='false' link-

type='outer' alias='a_******************5'>

<attribute name='accountnumber' />

<attribute name='aac_nearestairportid' />

</link-entity>

</entity>

</fetch>";

MessageBox.Show($"Count of Records:{totalCount.Entities.Count}");

}

public static int GetRecordCount(string fetchXml, string attributeName, ConditionExpression expression)

{

int rc = 0;

StringBuilder sb = new StringBuilder();

sb.AppendLine("<fetch distinct='false' mapping='logical' aggregate='true'> ");

sb.AppendLine(" <contact='" + fetchXml + "'> ");

sb.AppendLine(" <attribute name='" + attributeName + "' alias='" + attributeName + "_count' aggregate='count'/> ");

sb.AppendLine(" <filter type='and'>");

if (expression.Values.Count > 1)

{

sb.AppendLine(" <condition attribute='" + expression.AttributeName + "' operator='in'>");

for (int i = 0; i < expression.Values.Count; i++)

{

sb.AppendLine(" <value>" + expression.Values[i].ToString() + "</value>");

}

sb.AppendLine(" </condition>");

}

else

{

sb.AppendLine(" <condition attribute='" + expression.AttributeName + "' operator='eq' value='" + expression.Values[0].ToString() + "' /> ");

}

sb.AppendLine(" <condition attribute='statecode' operator='eq' value='0' /> ");

sb.AppendLine(" </filter> ");

sb.AppendLine(" </entity> ");

sb.AppendLine("</fetch>");

EntityCollection totalCount = _service.RetrieveMultiple(new FetchExpression(sb.ToString()));

if (totalCount.Entities.Count > 0)

{

foreach (var t in totalCount.Entities)

{

rc = (int)((AliasedValue)t[attributeName + "_count"]).Value;

break;

}

}

return rc;

}

}

Was this reply helpful? Yes No