Hello at all,
as the title says I have some issues with views and field collection. I want to build a block to show some titles of nodes from a content type which have the same terms from items of field collection.
So I built a view, filtered the content type with status published and added the relation CONTENT:XY where XY is the field collection.
Then I added a contextual filter with the field collection item from field XYZ with delta:all. And I didn't get a result. Then I thought that because XYZ is a referenced taxonomy field in the field collection I have to go a step further.
So second step: After the first relation from above I added a second relation to this with field collection item from field ....
The contextual filter I submit was then term from field XYZ. The UID from views suggested to chose the field collection but there is no result again...
So what do I miss here? Anybody has the same experience?
Another question in general for views:
Earlier in views 2 you could see the SQL statement in views. Where is this feature gone?
THX in advance
maen
Comments
Comment #1
joel_osc commentedTough to tell what is going on from your description, but your contextual filter may be looking for a term id. You can turn on the SQL under admin/structure/views/settings - which is likely a good step.
Comment #2
potassiumchloride commentedSounds like it is related to #1973090: Relationship to Field Collection not working, if not the same. Try turning off the views cache.
Comment #3
jkingsnorth commentedIn answer to the second part of your question, you can turn on the SQL view under Structure > Views > Settings: Live Preview Settings: tick 'Show information and statistics about the view during live preview': tick 'Show the SQL query' ... (phew)
Like joel_osc, it's a bit hard to get my head around exactly what you're trying to achieve in the View, could you try explaining it again?
Comment #4
jkingsnorth commentedClosed due to inactivity