Plugin: Category Count

That’s great. Although, I currently use the EE Query module to count the entries in a category. But you need a personal or commercial license of EE to get that worked out. EE Query module isn’t included in the free core edition.

{exp:weblog:categories weblog="{my_weblog}"}
    {exp:query sql="SELECT count(exp_category_posts.entry_id) AS post_count    FROM exp_category_posts WHERE exp_category_posts.cat_id = {category_id} "}
        <a href="http://{path={my_template_group}/index}">{category_name}</a> ({post_count})
    {/exp:query}
{/exp:weblog:categories}

So with this plugin, users of the free core edition can show the number of items per category, nice one!

Nice plugin. There’s one disadvantage on both solutions: they also count the closed and other statuses. Maybe adjust the query so that only open entries are selected?

SELECT count(exp_category_posts.entry_id) AS post_count    FROM exp_category_posts WHERE exp_category_posts.cat_id = {category_id}

This SQL query will show all entries for that category, even if they might have a status where the entry is not visible to the user. In order to check for the status, you’d have to JOIN the category posts with at least one more table.

Just a thought, this is how we do it on our website where we don’t want categories for closed entries (or not open) be included in the count.

@ron00nor

There’s one disadvantage on both solutions: they also count the closed and other statuses. Maybe adjust the query so that only open entries are selected?

That was a great call! I updated the plugin to accept status as a parameter. It defaults to just entries with status=”open”

You can get the uploaded version in the original post.

Thanks for the idea 😊

Perhaps a quick update to the first post to let people know that they can now use the status=”closed|featured” parameter in the plugin tag? 😉

Also I’m not fantastic with SQL queries but just wondering if there are a lot of statuses would the IN(‘closed’, ‘featured’) SQL query work better than lots of ANDs.

As I say I know just enough SQL to put together a query so not sure on that one?

Thanks for a great little plugin by the way! 😊

Best wishes,

Mark

Hey Mark,

Thanks for the suggestions. If you aren’t an expert, that makes me even less of one! I haven’t used IN before, but i will check it out.

Thanks for the suggestion! Zac

Hi Zac,

My plugin Entries Number can achieve the same as yours - to output the number of entries posted into some category and having certain status.

@Laisvunas - Ha! That makes the second plugin I worked on that you had already developed in a more robust fashion 😊 I guess that means I’m going in the right direction.

Thanks for tuning me in.

Cheers, Zac

Hey Mark, Thanks for the suggestions. If you aren’t an expert, that makes me even less of one! I haven’t used IN before, but i will check it out. Thanks for the suggestion! Zac

Let me know what you find out 😉

Thank you so much. One of those simple features you expect to be in the original code. Relieved to find someone who has taken the time to not only create it, but share it.

Works great. Thanks Zac!

cancelled! wrong reply!

This is just a notice that you can now find an EE2 version of the plugin in the original post 😊

Great plugin Zac!

How would I find the number of uncategorised entries using your plugin?