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?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

sahara 645 on at

Like (0)

Report
Copy link

Link copied!

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 = ''

Was this reply helpful? Yes No
Suggested answer

Mohamed Sanuj Basheer 540 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No