Hi All,
If I have Entity Attribute id and Entity Id .How can find data from this Entity Id and corresponding Entity Attribute id ??
Or Is It Possible???
Example- Entity Name- Placeholder
Entity Id-1222
Attribute Name- Placeholder_Name
Attribute Id-123
Thanks
Mansur
Hey @MD Mansur ,
Yes, it's possible to find entities and entity attributes. You can use these system tables
Hope this helps
I know but how to find data from entity???
What kind of data are you talking about?
Data:
This Enity Data
That would need a really advanced query to be able to get that. Why would you want to do that? Is that some kind of requirement?
Without advance sql query . its is not possible???
or Can we done with the help of aggreagate??
I don't think so, because you want to access an entity's data using metadata, instead of just an usual aggregate. So you're not simply calling the entity, and you can't join your tables with these system tables.
You'll need a work around, using subqueries, to get to your data through the metadata
If I understand correctly, you have an entity with an ID (Entity Id), an associated attribute with an ID (Entity Attribute Id), and you want to retrieve data related to these IDs. However, you also mention "Entity Name," "Attribute Name," and "Attribute Id" in your example.
If you have a database or a data structure where entities and attributes are stored, you can perform a query to CRM data enrichment based on the provided IDs. Here's a generic example of how you might structure a query:
SELECT attribute_valueFROM your_tableWHERE entity_id = 1222 AND attribute_id = 123;