Thread

What is the easiest/least resource-demanding way of counting the number of entries in a channel? I need a way to just say “There are 32 entries in channel xxx (with status blablabla and category xxx)”...

@ndre

Hiya,

There is the Statistics Module which will allow you to retrieve these variables :

{last_comment_date format="%m/%d/%Y %h:%i %a"}
{last_entry_date format="%m/%d/%Y %h:%i %a"}
{last_visitor_date format="%m/%d/%Y %h:%i %a"}
{most_visitor_date format="%m/%d/%Y %h:%i %a"}
{most_visitors}
{total_anon}
{total_comments}
{total_entries}
{total_guests}
{total_logged_in}
{total_members}

Anything past that though and you would probably be looking at a query to get at what you need in the most efficient way.

Hope that helps a bit.

Best wishes,

Mark

Ok, solved it with a custom query. Had to do selects with different statuses and different categories. Feels hacky though…. 😊