I have a table (screens shot attached)where all the terms which are attached to custom entities are stored,I wanted some help in creating db schema to get all the terms.
Where , terms on profile2 = terms on node
I am facing difficulty, here because one term reference field is in filed collection field
i.e i want list of terms from prifle2 + terms from field collection item
the table name is taxonomy_term_entity_index
please help

CommentFileSizeAuthor
tei_table_acreenshot.PNG47.93 KBkaizerking

Comments

jmuzz’s picture

jmuzz commented
Issue summary: View changes
Status: Active » Fixed

So you have a node with a field collection item and you need to get the term from inside the field collection, right? The value of the field in the node is the ID of the field collection item. You want the row in the field data table for the taxonomy term field that has that ID as the entity_id and 'field_collection_item' as the entity_type.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.