I am working on a project that hundreds of files attached to nodes with a field field. Each of the nodes also has term references to a type, category and sub-category. I also have field collections that can hold additional categories and sub-categories. The goal would be to get all of the files related to any category | sub-category combo.
When I try and do this by using a relationship with the field collection and then filtering on the field collection fields for category and sub-category it does not work. I am looking into why this is but I also need to consider other ways of displaying this information.
An example of this would be nodes with A|A, A|B&A|A, A|B, A|A, C|A
the query would return the results of A|A, A|B&A|A, A|A
I may be over thinking this but appreciate any help I can get.
Thanks, Steve
why are you using field collection for category > sub category and not a multi valued taxonomy with hierarchy ?
On Wed, May 29, 2013 at 8:03 PM, Steve Kessler skessler@denverdataman.comwrote:
I am working on a project that hundreds of files attached to nodes with a field field. Each of the nodes also has term references to a type, category and sub-category. I also have field collections that can hold additional categories and sub-categories. The goal would be to get all of the files related to any category | sub-category combo.
When I try and do this by using a relationship with the field collection and then filtering on the field collection fields for category and sub-category it does not work. I am looking into why this is but I also need to consider other ways of displaying this information.
An example of this would be nodes with A|A, A|B&A|A, A|B, A|A, C|A
the query would return the results of A|A, A|B&A|A, A|A
I may be over thinking this but appreciate any help I can get.
Thanks, Steve
-- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
-- [ Drupal support list | http://lists.drupal.org/ ]
When I first did this it seamed to make more sense to break it up because we use the top category to match some data in an external system but I am not sure we still need to. But this would not solve the problem because I will still need to know what is primary and what is secondary which is why I had the field collections in the first place.
-Steve
On Wed, May 29, 2013 at 11:11 AM, Idan Arbel idan@arbel-designs.com wrote:
why are you using field collection for category > sub category and not a multi valued taxonomy with hierarchy ?
On Wed, May 29, 2013 at 8:03 PM, Steve Kessler <skessler@denverdataman.com
wrote:
I am working on a project that hundreds of files attached to nodes with a field field. Each of the nodes also has term references to a type, category and sub-category. I also have field collections that can hold additional categories and sub-categories. The goal would be to get all of the files related to any category | sub-category combo.
When I try and do this by using a relationship with the field collection and then filtering on the field collection fields for category and sub-category it does not work. I am looking into why this is but I also need to consider other ways of displaying this information.
An example of this would be nodes with A|A, A|B&A|A, A|B, A|A, C|A
the query would return the results of A|A, A|B&A|A, A|A
I may be over thinking this but appreciate any help I can get.
Thanks, Steve
-- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Idan Arbel -
Steve Kessler