Hi,

THis should be easy, but I can't get it to do what I want. I am trying to design a View, which should "simply" provide me with a list of all authors (I defined a CCK field "Author", because the regular Drupal author field is actually the submitter of a text, which, in my case, is different from the one who actually wrote it).

I want just one field in my View, i.e. this CCK Author field. I "group by" this field, and sort them Ascending. No filters, because I want all Authors.

And that's what I get, but the list is full of duplicates. How can I get my view to show Author X just once, even though he wrote several nodes?

Ludo

Comments

nancydru’s picture

modul’s picture

Well, it seems to be tougher than I imagined... How to find the Unique values of a CCK field, say "Author_of_articles"? Obviously, one author_of_articles can write more than one article, but I would like his/her name to occur only once in a View... Can this be done? Sure hope so... Any hints on how to put this View together?

Ludo

modul’s picture

OK, solved it. The trick to get a list of multiple authors (a CCK field "author", that is), has to do with defining a View with this argument:
- select the field you want to see,
- and as default, select "Summary, sort ascending".
That's it. You'll get something like:

Dostojevski (27)
Hemingway (45)
Oz (12)

If you add more fields in the Fields selection area, e.g. titles, and you then click the author when the View is executed, you get all articles contributed by the author you clicked. Just what I wanted!

Ludo

nancydru’s picture

I'm not using CCK, I just want to list the authors of stories, along with how many they've done.

I don't see a "Summary, sort ascending" option anywhere.

Nancy W.
now running 5 sites on Drupal so far
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in Your Database

modul’s picture

"Summary, sort ascending" is an option under the "Arguments" section of the "Views" administration. I haven't tried it with the standard Drupal's "author" field, but that shouldn't make any difference.

Ludo

gregarios’s picture

I'm trying to get the output from the list to appear as you've shown, but be sorted by node count... any ideas?