Forum Discussion

Puljac's avatar
Puljac
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 communi...
  • Inactive User's avatar
    Inactive User
    11 years ago

    In Freemarker, that'd be:

     

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

     

Puljac's avatar
Puljac
Maven
11 years ago

Thank you Inactive User that was exactly what i was looking for....

 

 

  • luk's avatar
    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 />