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

joel_osc’s picture

Tough 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.

potassiumchloride’s picture

Sounds like it is related to #1973090: Relationship to Field Collection not working, if not the same. Try turning off the views cache.

jkingsnorth’s picture

In 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?

jkingsnorth’s picture

Issue summary: View changes
Status: Active » Closed (cannot reproduce)

Closed due to inactivity