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.
Solved! Go to Solution.
Yes, you can achieve this.
1. Unresolved post.
SELECT * FROM messages WHERE is_solution = false
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'
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
Welcome to the Technology board!
Curious about our platform? Looking to connect on social technology? You've come to the right place!