count the number of articles

colak · 2019-05-28 05:48:30

I’m trying to figure out how to count the number of live+sticky articles per section and the whole site.

I tried <txp:article_custom section='<txp:section />' status="live,sticky" pageby="1" pgonly /> and <txp:article_custom section="list,of,sections" status="live,sticky" pageby="1" pgonly /> but the sticky articles are not counted. Is there a vanilla way?

jakob · 2019-05-28 07:49:10

Two ideas: what happens if you use just status with no value. If I’ve understood that correctly from other threads, omitting the value means it counts both (or all?) statuses, but I’m not sure if that applies just to txp:article and not to txp:article_custom:

<txp:article_custom section="list,of,sections" pageby="1" pgonly status />

I think using pgonly bypasses the default limit value of 10, but if not, you may need to set limit="9999" too.

The other way might be to do the article count for each status and add the result together using variables.

<txp:variable name="article_count" value='<txp:article_custom section="list,of,sections" pageby="1" pgonly status="live" />' />
<txp:variable name="article_count" add='<txp:article_custom section="list,of,sections" pageby="1" pgonly status="sticky" />' />
<!-- then output it where you need it -->
<txp:variable name="article_count" />

Do either/both of those work?

colak · 2019-05-28 10:01:05

^^ that did the trick! For learning purposes, I wonder if it will be less load on the server if the evaluate tag is used.

jakob · 2019-05-28 14:56:13

colak wrote #318262:

^^ that did the trick!

Great! Just so we know: which of the two suggestions worked for you?

For learning purposes, I wonder if it will be less load on the server if the evaluate tag is used.

You may be onto something there. Oleg can probably say…?

colak · 2019-05-28 15:09:49

jakob wrote #318273:

Great! Just so we know: which of the two suggestions worked for you?

I implemented it in to ways here and here.

jakob · 2019-05-28 15:43:29

Just a small minor-tweak: if you want to output the variable’s valuable immediately where you’ve defined or calculated it, you should be able to simply add output (or output="1") to the tag with the add attribute and drop the extra list item. That attribute was added in txp 4.7.2.

colak · 2019-05-28 16:07:19

Indeed. Implemented! Search for your name here :)

etc · 2019-05-29 05:06:26

<txp:article_custom section="list,of,sections" status pgonly pageby="1" />

should be fine. I don’t remember why we have not implemented status="live, sticky" too. Probably because it would be not bw-compatible (though the risk is minimal) and Stef had some further plans re status.

colak · 2019-05-29 05:47:02

etc wrote #318282:

<txp:article_custom section="list,of,sections" status pgonly pageby="1" />...

should be fine. I don’t remember why we have not implemented status="live, sticky" too. Probably because it would be not bw-compatible (though the risk is minimal) and Stef had some further plans re status.

Hi Oleg,

Indeed it does although it is slightly counter-intuitive as it does not explicitly tell us that it will omit draft and pending statuses.

etc · 2019-05-29 08:06:32

colak wrote #318283:

Indeed it does although it is slightly counter-intuitive as it does not explicitly tell us that it will omit draft and pending statuses.

The idea was to select all articles having a “visible” status, be it live, sticky or some future one. You can not output “hidden” statuses anyway, by privacy concern.

jakob · 2019-05-29 08:15:56

etc wrote #318288:

The idea was to select all articles having a “visible” status, be it live, sticky or some future one. You can not output “hidden” statuses anyway, by privacy concern.

Excellent! And makes sense. Thanks for clarifying.

Kjeld · 2020-07-15 11:02:10

This works perfectly. Thank you very much!

One question:

How can I add a comma as a thousands separator for the resulting number?

“6,357 images” instead of “6357 images”

etc · 2020-07-15 12:00:35

Kjeld wrote #324536:

How can I add a comma as a thousands separator for the resulting number?

“6,357 images” instead of “6357 images”

Try adding escape="number" attribute to the outputting tag.

colak · 2025-08-07 06:14:24

I’m returning to this as I was experimenting with the evaluate tag which did not work as expected and returned nothing when using the snippet below.

<txp:evaluate query='<txp:article_custom section="projects,about,blog,texts,publications" pageby="1" status="live" pgonly escape="number" /> + <txp:article_custom section="projects,about,blog,texts,publications" pageby="1" status="sticky" pgonly escape="number" />' />

I know that the above can be achieved in a simpler way and it is not a real life experiment.

jakob · 2025-08-07 07:00:51

Try removing escape="number" from your tags. According to the post above that adds a comma, which is probably throwing off the addition.

Textpattern CMS

Textpattern CMS support forum

#1 2019-05-28 05:48:30