Get the attributes columns data from Fetch XML through Custom workflow

(0) Share

Report

Posted on by naresh babu

425

Hi Guys,

My requirement is to get attribute fields data from Fetch XML through custom workflow.
I have approach retrievemultiple with fetchxml query.
I got the count of the records through fetchxml and now i want to get the first column data of fetchxml through custom workflow.

In the below image, i want to get the "Subject" column data.

Below logic:

string query2 = @"<fetch version='1.0' mapping='logical' distinct='false' >
<entity name='task'>
<attribute name='subject' alias='task_count' />
<order attribute='subject' descending='false' />
<filter type='and'>
<condition attribute='statecode' operator='eq' value='0' />
</filter>
</entity>
</fetch>";

EntityCollection result = service.RetrieveMultiple(new FetchExpression(query2));

foreach (var c in result.Entities)
{
string aggregate = c.Attributes["subject"].ToString();
}
}

//string contactField2 = contact.GetAttributeValue<string>("firstname");- is working for only first record.

By this logic i got only first value. Can any suggest me the solution to get the data first column through fetchxml.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi there,

If you simply need some value from the first record - you can simply do something like below you dont need to foreach in the retrieved collection. just pick the first record from collection by doing [0].

EntityCollection collection = crmService.RetrieveMultiple(new FetchExpression(fetch));

if (collection.Entities.Count > 0)

{

string name = "";

if (collection[0].Contains("name"))

name = collection[0]["name"].ToString();

}

Was this reply helpful? Yes No
naresh babu 425 on at

Like (0)

Report

Hi Rawish Kumar,

Thanks for you reply. I tried this also. But my requirement is not for single record. I need all subjects column as shown in image.

Was this reply helpful? Yes No
Suggested answer

crm development 870 on at

Like (0)

Report

Hi, you can create list and collect Subject column data in List. Or you can create Dictionary to collect Subject and related record id.

Refer below code for List. Hope this helps.

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

List<string> SubjectList = new List<string>();

foreach (var c in result.Entities)

{

SubjectList.Add(c.Attributes["subject"].ToString());

}

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

Thanks,

Anand

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Okay understood. Then its fairly simple.

Create an array list and add value to this within your foreach loop.

You can then access the values from the list and use them.

Was this reply helpful? Yes No
Flydancer 1,332 on at

Like (0)

Report

Hi N B,

your code looks like it does what you want. Can you explain what exactly your problem is?

Was this reply helpful? Yes No
naresh babu 425 on at

Like (0)

Report

Hi Flydancer

Actually, i need the subject column as my output as shown in image.

Was this reply helpful? Yes No
naresh babu 425 on at

Like (0)

Report

Hi Anand Wani, Thanks for your reply

I have tried your script. But it was not working. error occurred like :-

An unexpected error occurred from ISV code. (ErrorType = ClientError) Unexpected exception from plug-in (Execute): -----deployed Solution Name--- : System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

This error generally occurs when you try to access a key ( field) which is not prresent in the collection.

could you please debug your code and see on which line its coming.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Anand's code is perfectly fine and i could see its working:

var fetch = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='activitypointer'>
<attribute name='activitytypecode' />
<attribute name='subject' />
<attribute name='statecode' />
<attribute name='prioritycode' />
<attribute name='modifiedon' />
<attribute name='activityid' />
<attribute name='instancetypecode' />
<attribute name='community' />
<order attribute='modifiedon' descending='false' />
<filter type='and'>
<condition attribute='subject' operator='not-null' />
<condition attribute='activitytypecode' operator='eq' value='4212' />
</filter>
</entity>
</fetch>";

EntityCollection collection = crmService.RetrieveMultiple(new FetchExpression(fetch));

List<string> SubjectList = new List<string>();
foreach (var sub in collection.Entities)
{
SubjectList.Add(sub.Attributes["subject"].ToString());
}
SubjectList.ForEach(i => Console.Write("{0}\n", i));
Console.ReadKey();

Was this reply helpful? Yes No
Suggested answer

crm development 870 on at

Like (0)

Report

Yup. I agree with Rawish. Code mentioned should work as it is. Please check you have written correct attribute name and debug the code if possible.

Thanks,

Anand

Was this reply helpful? Yes No