Question

0

Access Attributes in a sql select statement

Eyob Zeleke posted 5 Years Ago

We have created attributes to the Person table and I am trying to retrieve the values in a select statement in SQL. Can someone show me a sample SQL statement showing how to grab attributes? Thank you!

0
- David Stevens replied 5 Years Ago
You would need to join the Person table to AttributeValue on the Person.Id = AttributeValue.EntityId.
However, multiple entity types could match by the same ID, so you'd want to limit that query by a specific AttributeId and/or join to Attributes where the Attribute Entity Type is a Person.
Edit Answer

You would need to join the Person table to AttributeValue on the Person.Id = AttributeValue.EntityId.However, multiple entity types could match by the same ID, so you'd want to limit that query by a specific AttributeId and/or join to Attributes where the Attribute Entity Type is a Person.
You would need to join the Person table to AttributeValue on the Person.Id = AttributeValue.EntityId.However, multiple entity types could match by the same ID, so you'd want to limit that query by a specific AttributeId and/or join to Attributes where the Attribute Entity Type is a Person.
You would need to join the Person table to AttributeValue on the Person.Id = AttributeValue.EntityId.However, multiple entity types could match by the same ID, so you'd want to limit that query by a specific AttributeId and/or join to Attributes where the Attribute Entity Type is a Person.
Save Cancel