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 /> ...

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 />