Lithium admin statistics

[kurtzi]

Hi Guys,

Second post of me trying to decide whether I should use Lithium as a community support forum.

I'm googling it for some time but couldn't find a focused answer...

As an admin, I'd really like to know some general statistics such as:

1. Unresolved posts.

2. Correct answers per users (and kodus, comments, etc.)

3. Filtering posts by time (let's say 'all posts since X till Y') 

and some more of these.

Are there ways for me to get it?

I's prefer some sort of a dashboard (but even admin console with REST API would be fine).

Thanks 🙂

Liran.

[TariqHussain]

@kurtzi-

Yes, you can achieve this.

[TariqHussain · Accepted solution]

@kurtzi-

1. Unresolved post.

SELECT *  FROM messages WHERE is_solution = false

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...

2. Correct answers per users (and kodus, comments, etc.)

Kudos Count

Select  kudos_received.sum(weight)  from users where id = '<user.id>'

Answers Count

SELECT solutions_authored.count(*) FROM users WHERE id = '31'

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...)

3. Filtering posts by time (let's say 'all posts since X till Y') 

SELECT subject, id FROM messages WHERE post_time > 2013-10-07T10:04:30-08:00 AND post_time < 2013-11-07T10:04:30-08:00 

https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collecti...