Get option set label from fetchXML aggregate query.

(0) Share

Report

Posted on by Community Member

Hi,

I'm trying to get the option set label from the fetchXML query with no luck.

I've read many posts and tried different ways to retrieve the option set values that are aggregated (group by) in the fetchXML.

Below is my query.

var strQuery = $@"
                <fetch aggregate='true'>
                  <entity name='custasset'>
                    <attribute name='name' alias='totalCount' aggregate='count' />
                    <attribute name='field1' alias='sv' groupby='true' />
                    <attribute name='field2' alias='shv' groupby='true' />
                    <attribute name='field3' alias='rg' groupby='true' />
                    <filter type='and'>
                      <condition attribute='field1' operator='not-null' />
                      <condition attribute='field2' operator='not-null' />
                      <condition attribute='field3' operator='not-null' />                    
                    </filter>
                  </entity>
                </fetch>";

Here is the casting that I tried to get the label. It doesn't even give the option set value.

1. String optValue = (String)((AliasedValue)c["shv"]).Value; 
2. String optValue = c.GetAttributeValue<String>("sv");

It would be a great help if anyone suggest/guide on how to do this.
Thanks,
Sandip

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

EntityCollection results = (EntityCollection)service.RetrieveMultiple(new FetchExpression(strQuery));

foreach (var c in results.Entities) {

System.Console.WriteLine(c.Attributes["shv"]);

//Here I want to get the option set label or value if label is not possible.

}

Was this reply helpful? Yes No
Suggested answer

Abby Kong 6 on at

Like (1)

Report
Copy link

Link copied!
Hi Sandip,

Include below function in your code and call with GetOptionSetValueLabel("custasset", "field2", ((OptionSetValue)((AliasedValue)c["shv"]).Value).Value, service):

public static string GetOptionSetValueLabel(string entityName, string fieldName, int optionSetValue, IOrganizationService service) { var attReq = new RetrieveAttributeRequest(); attReq.EntityLogicalName = entityName; attReq.LogicalName = fieldName; attReq.RetrieveAsIfPublished = true; var attResponse = (RetrieveAttributeResponse)service.Execute(attReq); var attMetadata = (EnumAttributeMetadata)attResponse.AttributeMetadata; return attMetadata.OptionSet.Options.Where(x => x.Value == optionSetValue).FirstOrDefault().Label.UserLocalizedLabel.Label; }

Regards,

Abby

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Abby,

It worked like a charm, buddy.!!

Thank you very much :)

Sandip

Was this reply helpful? Yes No
michael raam on at

Like (0)

Report
Copy link

Link copied!

Hi,

I can use only FetchXML with out any code around it, how would it be possible to retrieve the option set values. Right now I'm getting only the ID.

Tnx,

Micahel

Was this reply helpful? Yes No