Hello!
I've got a fairly simple View that pulls email addresses from a subset of node types. There's an argument and a couple filters involved. I'm also using Views Field View. Here's the query:
SELECT DISTINCT(node.nid) AS nid, node_node_data_field_registeringteam.nid AS node_node_data_field_registeringteam_nid, node.nid AS node_nid FROM node node LEFT JOIN content_type_gameregistration node_data_field_registeringteam ON node.vid = node_data_field_registeringteam.vid LEFT JOIN node node_node_data_field_registeringteam ON node_data_field_registeringteam.field_registeringteam_nid = node_node_data_field_registeringteam.nid LEFT JOIN content_type_gameregistration node_data_field_registeredgame ON node.vid = node_data_field_registeredgame.vid LEFT JOIN node node_node_data_field_registeredgame ON node_data_field_registeredgame.field_registeredgame_nid = node_node_data_field_registeredgame.nid LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2 WHERE (node.type in ('gameregistration')) AND (flag_content_node.uid IS NULL) AND (node_node_data_field_registeredgame.nid = 151 ) GROUP BY nid ORDER BY node_nid ASC
I've got a feed and a page display. The default and the page show just fine (the "151" is just my test argument). The display view spits out highly unexpected results! Doesn't matter if I've chosen .xls or .txt or .csv or whatever, I never get the simple output that the default or page displays gives me: just a simple column of emails. What I'll get instead is, like, two or three emails repeated as many times as there are emails.
Is this a Views Field View issue? A feed display issue? The Views Field View pulls up, as I said, just fine in default and page.
List as a "support" query because perhaps I'm not understanding the functionality of the feed display. I've used it before to pull node lists or whatever, but never with the Views Field View. Does the feed output handle the query differently?
Thanks!
p.
Comments
Comment #1
dawehnerI'm not really sure what you did but i guess the problem is using views_field_view in a csv context as views_field_view actually renders a full subview.
Comment #2
pbeakley commentedInteresting! So this happens in every output case: txt, csv, xml, xls and so on. Any ideas on how that behavior might be turned off?
Thanks!
Comment #3
dawehnerLet's move to views data export, maybe they have a better idea.
Comment #4
Azol commentedPlease test this patch in #1 - it worked for me (I use Views 3 by the way)
#2037441: Export is not correctly paginating using Views 3.x and 6.x-2.x-dev
Comment #5
greggadsdon commentedAs Drupal 6 nears the end of its life and support period, the 6.x version of Views Data Export will not be supported either. To that end, this issue has been closed, and will not be resolved in the 6.x branch of Views Data Export.
If this issue is still relevant to 7.x branch of Views Data Export, then please re-open and move to a relevant 7.x version.