Is there a way to find which entity a particular field belongs to?

(0) Share

Report

Posted on by cranialsurge Microsoft Employee

I'm working on a Dynamics CRM 2015 environment and am searching for a particular field. I know it exists, but am not sure which entity it is on. The system is heavily customized and has a ton of entities (OOTB+custom). Is there an easy way to find a particular field if I know its schema name?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mithilesh Kumar 10,047 on at

Like (0)

Report
Copy link

Link copied!

Hi Cranialsurge,

You cannot find the entity name based on the field name.

Entities are separate table in SQL Database, and they can have identical fields also between them.

eg: Entity A having field name "new_description" and Entity B having field name "new_description"

Hope that helps

Thanks

Was this reply helpful? Yes No
Verified answer

Royal King 27,686 on at

Like (2)

Report
Copy link

Link copied!

Is it on-premise or online ? if you have on-premise version of crm you could use below query to find entity name as well all the required information about an attribute

SELECT MetadataSchema.Attribute.Name, MetadataSchema.Attribute.AttributeRequiredLevelId, MetadataSchema.Attribute.PhysicalName, MetadataSchema.Attribute.Length,

MetadataSchema.Attribute.MaxLength, MetadataSchema.Attribute.DefaultValue, MetadataSchema.Attribute.VisibleToPlatform, MetadataSchema.Attribute.IsPKAttribute,

MetadataSchema.Attribute.PrecisionValue, MetadataSchema.Attribute.MinValue, MetadataSchema.Attribute.MaxValue, MetadataSchema.Attribute.AttributeId,

MetadataSchema.Entity.Name, MetadataSchema.Entity.OriginalLocalizedName

FROM MetadataSchema.Entity INNER JOIN

MetadataSchema.Attribute ON MetadataSchema.Entity.EntityId = MetadataSchema.Attribute.EntityId

Was this reply helpful? Yes No
Bhuvaneswary Rajase... 405 on at

Like (1)

Report
Copy link

Link copied!

yes indeed by writing a sql query provided u have access to db.

SELECT EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName,
LocalizedLabelView_2.Label AS AttributeDisplayName, AttributeView.Name AS AttributeName,
Type = (select XmlType from MetadataSchema.AttributeTypes where AttributeTypeId = AttributeView.AttributeTypeId)
FROM LocalizedLabelView AS LocalizedLabelView_2
INNER JOIN AttributeView ON LocalizedLabelView_2.ObjectId = AttributeView.AttributeId
RIGHT OUTER JOIN EntityView
INNER JOIN LocalizedLabelView AS LocalizedLabelView_1 ON EntityView.EntityId = LocalizedLabelView_1.ObjectId
ON AttributeView.EntityId = EntityView.EntityId
WHERE LocalizedLabelView_1.ObjectColumnName = 'LocalizedName'
AND LocalizedLabelView_2.ObjectColumnName = 'DisplayName'
AND LocalizedLabelView_1.LanguageId = '1033'
AND LocalizedLabelView_2.LanguageId = '1033'
AND EntityView.Name IN ('contact')
order by AttributeName

Ref - http://mscrm-chandan.blogspot.in/2013/04/get-all-attribute-detail-of-entity-in.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I'm trying to determine where the Entity Definition / Areas that display this entity info is stored in the database?

Was this reply helpful? Yes No
D365Life on at

Like (0)

Report
Copy link

Link copied!

Does anyone have an answer to this question? How do you find the entity from a CRM Form?

Was this reply helpful? Yes No