In the EE database, I see that exp_channel_fields
.field_id
= 4 refers to a relationship in my Channel-A
(channel_id = 1). I assume that channel data for that field should be stored in my exp_channel_data
.field_id_4
. Is this right? I do not see any data in that column, despite me going into Channel-A and making sure that I have selected a value from the relationship field.
I'm trying to build a query that gets a distinct list of url titles from the relationship field if that title was selected in Channel A.