API & FreeMarker Issue Tracker
As there is no public issue tracker (afaik) or reporting workflow (other than support tickets and ideas), I'd like to collect some things that were found trough hour-long trial end error (some includ...
Forum Discussion
Issue: #1
Type: BUG
Area: REST API v2
Collection: messages
Platform Version: <= 19.7
Summary: The function count(topic) does not work as documented.
Ping: SuzieH
The docs state that "count(topic): The count of topics on a community, category, or board", which would theoretically allow a query like:
// query1
SELECT count(topic) FROM messages WHERE board.id = '<board.id>'
if the above worked, it would shorten/make more readable the "regular" query of getting a topic count on a node, which at the same time is the workaround:
// query2
SELECT count(*) FROM messages WHERE depth = 0 AND board.id = '<board.id>'
ISSUE: The expected output from query1 would be the SAME count as returned by query2, but the count returned is the same as if depth = 0 was omitted, e.g. the total count of messages in the node.
