Forum Discussion

Kev_B's avatar
Kev_B
Advisor
7 years ago

Do date constraints work with API v1?

Hi, I'm using API v1 for the first time to pull up some user stats, and I'm trying to constrain these to a date range. I've tried using ?date_start-YYYY-MM-DD&date_end-YYYY-MM-DD at the end of the q...
Kev_B's avatar
Kev_B
Advisor

Thanks Vikas, 

I'm most interested in using the count function on posts, is there an easy way to do this with API v2?

Thanks

PerBonomi's avatar
PerBonomi
Boss
7 years ago

This is a starting point:

<#assign user_id = 123/>
<#assign board_id = 'help'/>
<#assign date_start = "yyyy-MM-dd"/>
<#assign date_end = "yyyy-MM-dd"/>
<#assign timezone = "+01:00"/>
<#assign query = rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = '${board_id}' AND author.id = '${user_id}' AND post_time >= ${date_start}T00:00:00${timezone} AND post_time <= ${date_end}T00:00:00${timezone}"?url) />
<#assign post_count = query.data.count!0/>
${post_count}