Two of the fields that I want the parent view to pass to the child view as arguments are defined in CCK using allowed values as key|label value pairs.
field_term: (sem1|Spring, sem2|Fall) <- defined as a text field
field_day: (1|mon, 2|tue, 3|wed, 4|thu, 5|fri) <- defined as an integer field
Other fields are just plain integer fields.
field_year: (2010, 2011, 2012, ...) <- defined as an integer field
When the parent view passes only the field_year argument, there is no problem and the child view is rendered correctly. However, with either of the other two fields, there is no child view result. Looking closely at the "Other Queries" in the Live Preview at the bottom of Views, I find that the SQL query does not contain the keys. Rather, for the text field, the query runs on the label and for the integer field, the query runs on '0' (which I assume is somehow a numeric translation of the original label text) for ALL queries, no matter what the original value was. (relevant part of query shown below)
WHERE (node_node_data_field_slot_node_data_field_year.field_year_value = 2011) AND (node_node_data_field_slot_node_data_field_term.field_term_value = 'Spring') AND (node_node_data_field_slot_node_data_field_day.field_day_value = 0)
I've spent all afternoon trying to solve this problem and searching these issues for any help, but either nobody's encountered this before (unlikely, I suppose), or I just don't understand enough about drupal, views, sql, and php to decipher recognize a relevant solution. If anyone has any guidance, I'd appreciate it.
Thanks.
Edit: Sorry, I should have mentioned that I'm using Views Field View 6.x-1.0-beta1 on Drupal 6.26.
Comments
Comment #0.0
fildpauz CreditAttribution: fildpauz commentedadded version info
Comment #1
jibranDrupal 6 compatible versions of the module are not supported anymore.