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

I have the same question (0)

All responses (3)

Answers (1)

ashlega 34,477 on at

Like (1)

Report

Should be more or less like this:

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

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

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Try something like:

Guid id = ((EntityReference)c.GetAttributeValue<AliasedValue>("aliasname").Value).Id;

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates