db_select schema to get tids array merged to host entity tids [#1704586]

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

Comment	File	Size	Author
	tei_table_acreenshot.PNG	47.93 KB	kaizerking

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

jmuzz CreditAttribution: jmuzz commented 3 March 2015 at 19:25

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.