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

fildpauz’s picture

Issue summary: View changes

added version info

jibran’s picture

Status: Active » Closed (outdated)

Drupal 6 compatible versions of the module are not supported anymore.