fetchxml alias

(0) Share

Report

Posted on by sdnd2000

2,510

Hi, are we able to use alias for attributes? It seems like fullname attribute disappear if I use alias.

<fetch mapping="logical" output-format="xml-platform" version="1.0" distinct="false" >
    <entity name="contact" >
        <attribute name="fullname" alias="aliasname" />

    </entity>
</fetch>

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Hi sdnd,

There is an "alias" parameter, but I am not sure this that is what you are looking for.

Why do you need other names? Attribute display names will show up in the view column headers (that will never be new_, that will be a display name). In the custom SSRS reports, you can give those columns whatever name you choose. Take a look at the following article:

mscrmtutorials.blogspot.ca/.../using-alias-in-ms-crm.html

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report

Hi sdnd,

it does not disappear - if you are using FetchXml tester, it just does not work with the aliases properly, it seems.

Try this kind of url, and you'll see those aliased values:

https://<ORG_URL>/api/data/v8.2/contacts?fetchXml=<fetch mapping='logical' output-format='xml-platform' version='1.0' distinct='false' > <entity name='contact' > <attribute name='fullname' alias='test' /> </entity></fetch>

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Nithya Gopinath 17,078 on at

Like (0)

Report

HI,

We are able to use alias for attributes but we need to read the attribute values with the Alias name instead of the attribute name.

See: community.dynamics.com/.../use-of-alias-in-fetchxml

Hope this helps.

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi ,

Using alias the actual attribute name will replace with the alias name of the attributes in the Entity Collection as like as SQL query alias.

Please find below screenshot.

Hope this will answer your question.

Please mark as answer if this help.

Thanks

Goutam

Was this reply helpful? Yes No