Forum Discussion

VarunGrazitti's avatar
VarunGrazitti
Boss
10 years ago

Get the posts for specified time range in V1 or V2

As per this reply from NicoB,  we need to find the posts in the community created within the last 1 week. Instead of the board, I am trying this call for category, but it is not working, though it i...
Views
Sign in to react to this post
DougS's avatar
DougS
Khoros Alumni (Retired)
10 years ago

You would have to specify a timerange in the query (you need a start time and an end time). If you were coding this in an endpoint, you could generate the query you need with something like this:

 

<#assign now = dateSupport.now />
<#assign nowMs = now.millisecondsAsString /> 
<#assign weekBefore = now.addWeek(-1) />
<#assign weekBeforeMs = weekBefore.millisecondsAsString />
<#assign query = "SELECT count(*) FROM messages WHERE board.id = 'technology' AND post_time > " + weekBeforeMs + " AND post_time < " + nowMs + " ORDER BY post_time DESC" />

-Doug

Sign in to react to this post
irach15's avatar
irach15
Maven
10 years ago
thank you, yes, I've done something like that too. I was thinking if any faster way around :-)
Sign in to react to this post
  • sam2's avatar
    sam2
    Guide
    9 years ago
    We can use "rangeTime" attribute for that in our endpoint call for V1.
    eg:- /restapi/vc/search/messages/count?q="anything u want to search"&rangeTime=1M
    Sign in to react to this post