Forum Discussion

VarunGrazitti's avatar
VarunGrazitti
Boss
9 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...
DougS's avatar
DougS
Khoros Oracle

Hi Varun,

 

You should be able to get a count of messages (topics and replies together) via REST V2 if you exclude the depth parameter from your LiQL query -- a query like this should do the trick I believe:

 

SELECT count(*) FROM messages WHERE board.id = 'technology' AND post_time > 1454348367000 AND post_time < 1454953167993 ORDER BY post_time DESC

Probably what you are seeing with using the browser giving you no results is because we block authentication on the call (for security reasons). If you were to include a REST session key with your call in the browser, then you will most likely see the same results.

 

-Doug

irach15's avatar
irach15
Maven
9 years ago

hi DougS,

if I want to get the latest posts/or count  for the last week, not specifying a week, 

Is it any way to get the results?

I did try, not working:
SELECT count(*) FROM messages WHERE board.id = 'topics' AND post_time < 604800 ORDER BY post_time DESC

 

Any suggestions?