Forum Discussion

Maven

11 years ago

Custom count

Hi is there a way to call data from community.

I want to make a custom component that will show:

- how many overall TOPICS are in community

- how many overall POSTS (messages) are in community

- how many new posts in 24 hours are posted in community

thanks.

Inactive User
11 years ago
See http://lithosphere.lithium.com/t5/rest-api/bd-p/developers-rest-api. I don't remember the 24 hour one off the top of my head but here's the first two:

Domain.com/restapi/vc/topics/count - topic count
Domain.com/restapi/vc/posts/count - post count
Inactive User
11 years ago
In Freemarker, that'd be:

<#assign messages = rest("topics/count").value /> ...

4 Replies

Inactive User
11 years ago
See http://lithosphere.lithium.com/t5/rest-api/bd-p/developers-rest-api. I don't remember the 24 hour one off the top of my head but here's the first two:

Domain.com/restapi/vc/topics/count - topic count
Domain.com/restapi/vc/posts/count - post count
Inactive User
11 years ago
In Freemarker, that'd be:

<#assign messages = rest("topics/count").value /> ...
Puljac
Maven
11 years ago
Thank you Inactive User that was exactly what i was looking for....
luk
Boss
10 years ago
Puljac, how did you solve the 24 hour one?

"how many new posts in 24 hours are posted in community"

I did that with v2 API, but the count doesn't seem to be correct... basically I just want the posts of the current day...

<#local today = .now?string["yyyy-MM-dd"] + "T00:00:00-00:01" />
<#local query = "SELECT count(*) FROM messages WHERE depth = 0 AND post_time > " + today />