Hello,
This module will be a fantastic addition to CCK/Views. In testing it, I found that when Node A references Nodes 1, 2 and 3, the view only returns one of the referenced nodes (the Relationship delta is set to ALL. I'm hoping you can tell me whether this is a known behavior, or if I've missed something.

I appreciate any direction you can offer. Please let me know if more information or the exported view/SQL query would help.

Thanks!
Joy

Comments

sunshinee’s picture

sunshinee CreditAttribution: sunshinee commented
Title: Reverse relationship only returns one result » Return multiple values on single row?
Status: Active » Closed (fixed)

Ok, I figured out the behavior was caused by my use of the DISTINCT filter. I just need to display multiple values from the node reference field in a single row.

Thanks again for a great module! =)

liquidcms’s picture

liquidcms CreditAttribution: liquidcms commented
Status: Closed (fixed) » Active

can you explain how you did this? i don't see any way for Views 6.2 to do this.

basically multiple nodes of type A reference a node of type B

make a view listing nodes of type B and want a cell in the row for a specific node of type B to list all the nodes of type A which reference it.

currently i get duplicate rows for each node which references the parent node.

sunshinee’s picture

sunshinee CreditAttribution: sunshinee commented

Well, it's been a long time since I messed with this, but I'm pretty sure I used the field setting "Group multiple values" in Views. If you want to post the export code for your view, I'd be glad to take a look.

liquidcms’s picture

liquidcms CreditAttribution: liquidcms commented

hey, thanks for response.. i am pretty sure this can't be done so i have done this with a php field.

grouping multiple values would give you a different sort of display.. it would be a ton of little tables with a title being the field you are grouping on - as opposed to one table with multiple items per row