<div dir="ltr">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. <div>
<br></div><div style>-Steve </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, May 29, 2013 at 11:11 AM, Idan Arbel <span dir="ltr"><<a href="mailto:idan@arbel-designs.com" target="_blank">idan@arbel-designs.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">why are you using field collection for category > sub category and not a multi valued taxonomy with hierarchy ?</div>
<div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Wed, May 29, 2013 at 8:03 PM, Steve Kessler <span dir="ltr"><<a href="mailto:skessler@denverdataman.com" target="_blank">skessler@denverdataman.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">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. <div>
<br></div><div>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. </div>
<div><br></div><div>An example of this would be nodes with A|A, A|B&A|A, A|B, A|A, C|A</div><div><br></div><div>the query would return the results of A|A, A|B&A|A, A|A<br></div><div><br></div><div>I may be over thinking this but appreciate any help I can get. </div>
<div><br></div><div>Thanks,</div><div>Steve </div><span><font color="#888888"><div><br></div><div><br></div><div><div><br></div>-- <br>Steve Kessler<div>Owner and Lead Consultant </div><div>Denver DataMan, LLC </div>
<div><a href="tel:303-587-4428" value="+13035874428" target="_blank">303-587-4428</a></div>
</div></font></span></div>
<br></div></div><span class="HOEnZb"><font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><br></div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Steve Kessler<div>Owner and Lead Consultant </div>
<div>Denver DataMan, LLC </div><div>303-587-4428</div>
</div>