I have on coupon content type with 2 fields. One is named "Campaign Owner" and the other one "Campaign Name". One owner might have several coupons generated by the site for a campaign. So the owner will have for example 20 coupons with the same campaign name. I want to create a list of campaign names and group them with campaign owner. So the list should be something like this:

JACK(Owner Name)

  1. Camp1
  2. Camp2
  3. Camp3

JOE (Owner Name)

  1. camp4
  2. camp5
  3. camp6

I've tried to create this with views but what I get is not what I'm looking for. Here is it:


  1. Camp1
  2. Camp1
  3. Camp1
  4. Camp2
  5. Camp2
  6. Camp2


  1. Camp4
  2. Camp4
  3. Camp4
  4. Camp5
  5. Camp5
  6. Camp5

As you can see. It lists all the similar campaign names. But kneed to get rid of the similar items. How can I do such a thing?

  • Go to advance Query settings in view and check Distinct may gives correct result. – Krishna Mohan Feb 14 '14 at 8:48
  • @KrishnaMohan No it doesn't work. They are not the same cause each row belongs to a published content with different NID. So they might be similar for us but they are not for the views. – lameei Feb 14 '14 at 8:51

The answer is "views distinct" module which checks the values of each row and then removes/aggregates the similar ones.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.