Thread

So I am using a Channel to create some staff profiles. These staff also have a member_id so that they can post into a News Channel.

I want to create a page that lists the names of these staff, ordered by either latest post or number of posts.

This is what I have so far..

From the Staff Channel the {title} field gives me the staff members name, and the custom field {profile_id} gives me the member_id. Using the Countee plugin from Getee I can also grab the number of entries that member has posted in the News Channel.

{exp:channel:entries channel="staff"}
    {title} Entries:{exp:countee member_id="{profile_id}" channel="news"}
{/exp:channel:entries}

This returns all the info I need, but the problem is how to order it by number of posts, or most recent post within the News Channel. Any ideas, or would something like the User module be of use here.

cheers Kenny

Try the orderby parameter… http://ellislab.com/expressionengine/user-guide/modules/channel/parameters.html#par_orderby

Hi Cheif, I don’t think that will that work.

The profiles exist as entries in a Staff channel, however what I am trying to order this channel by is the number of entries that person has made in a different channel.

I am afraid you’ll need a custom SQL query for that.