Retrieve EntityRerence from an AliasedValue and convert that to a string - FetchXML

(0) Share

Report

Posted on by Stuie

255

I'm retrieving data using FetchXML but I'm struggling to check for the AliasValues, retrieve them and then make them strings for insertion in a SQLserver db.

I have it working for non Alias values as below;

if (c.Attributes.Contains("tri_school1type")){
        gSchoolType1 = c.GetAttributeValue<EntityReference>("tri_school1type").Id;
                }

gSchoolType1 is declared as a Guid then i convert out of the fetch loop to a string with;

var sSchoolType1Guid = gSchoolType1;
string sSchoolType1String = sSchoolType1Guid.ToString();

Many thanks

*This post is locked for comments

All responses (3)

Answers (1)

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Retrieve EntityRerence from an AliasedValue and convert that to a string - FetchXML

Also it would be good to close thread you opened earlier - community.dynamics.com/.../265357

Take a minute, open it and mark answers - I'm pretty sure there were such replies.
Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Retrieve EntityRerence from an AliasedValue and convert that to a string - FetchXML

Hello,

Try something like:

Guid id = ((EntityReference)c.GetAttributeValue<AliasedValue>("aliasname").Value).Id;
ashlega 34,475 on at

Like (1)

Report

RE: Retrieve EntityRerence from an AliasedValue and convert that to a string - FetchXML

Should be more or less like this:

object oVal = ((AliasedValue)c.Attributes["alias.attribute"]).Value;

Guid id= ((EntityReference) oVal).Id;