Customer experience | Sales, Customer Insights,...

how to get a field name using guid in sql

(0) Share

Report

Posted on by sahara

645

I have a list of fields guids and I need to get fields names from metadata by guids using SQL is there a way to do that ? if not what are my other options?

All responses (2)

Answers (0)

Suggested answer

Mohamed Sanuj Basheer 540 on at

Like (0)

Report

RE: how to get a field name using guid in sql

Dear Partner,

To get the field in the form, you can use Xrm Get Value function.

var varMyValue = Xrm.Page.getAttribute(“CRMFieldSchemaName”).getValue() ;

www.powerobjects.com/.../crm-2011-useful-javascript-tidbits

msdn.microsoft.com/.../gg334409.aspx

For example you want to get the Name, you don't need to use Id.

var varMyValue = Xrm.Page.getAttribute(“new_name”).getValue() ;

And if from Guid you can get any field using OData Query..

See this link to get started

missdynamicscrm.blogspot.com/.../tips-and-trick-odata-crm-2011-2013.html

Which you can query any field using this ide similar to SQL.

Regards,

Mohamed Sanuj Basheer
sahara 645 on at

Like (0)

Report

RE: how to get a field name using guid in sql

that did the trick for me :

SELECT e.Name as 'entity' ,a.Name as field

FROM [dbo].EntityView e

left join [dbo].AttributeView a on e.EntityId = a.EntityId

where a.attributeid = ''