Hello,

I'm trying to see if anyone can help me on this. I'm using Views for Drupal 6.

I have 2 different Vocabularies. Like
Vocabulary instruments has a list of terms such as:

  • pen
  • pencil

Vocabulary color has a list of terms such as

  • Green
  • Pink

Each content has two information: instruments AND color

Content drawings A has
Vocabulary instruments: Pen
Vocabulary color: Green

Content drawings B has
Vocabulary instruments: Pen
Vocabulary color: Pink

Content drawings C has
Vocabulary instruments: Pencil
Vocabulary color: Green

Content drawings D has
Vocabulary instruments: Pencil
Vocabulary color: Pink

Now I want to query such that:
List ALL term that is Pencil AND Pen that is not pink.
OR
List ALL term that is Pencil AND Pen that is green.

So this list would contain drawings A, C, D.

I can grab these lists in two separate views, but would like this in one same view. Have anyone encountered something like this?

Changing structure of Vocabulary is not an option for me. If you have constructive idea, please let me know.

Thank you!

Comments

Letharion’s picture

Letharion commented
Assigned: Unassigned » esmerel

I can't provide much help here, assigning to esmerel.

esmerel’s picture

esmerel commented
Assigned: esmerel » merlinofchaos
merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

You can't do this in Views 2. You can do this in Views 3.

chunty’s picture

chunty commented

@merlinofchaos can you clarify the bit of this you can't do in view 2 I'm presuming you mean the specific query that's being attempted here and in particular the NOT/OR combination logic:


List ALL term that is Pencil AND Pen that is not pink.
OR
List ALL term that is Pencil AND Pen that is green.

When I initially read this post I thought it was implying you can't do views across multiple vocabs but actually I've just made one work fine...at least I think I have.

Thanks
Chris

Letharion’s picture

Letharion commented

@chunty
It's important to re-open issues when you have further questions. You're unlikely to be noticed otherwise.

I think that it's the boolean logic that you can't do in Views 2.

Letharion’s picture

Letharion commented

You may want to look at the module Views_or

Letharion’s picture

Letharion commented
Issue tags: +boolean logic

Tagging for future reference

merlinofchaos’s picture

merlinofchaos commented

Correct, it's the complex boolean logic that Views 2 cannot handle. Since you're working with terms, views_or almost certainly won't work either.