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
