Hi All,
I would like to know how we can get the below metrics from database / rest api for the confluence questions plugin
1 ) no of accepted answers for a question
2) no of upvotes for a comment
Hello @marunmohan !
As I understand, you need to gather specific metrics from your Questions within Confluence.
Some time ago this request has shown up but in its place, a similar set of metrics has been made available.
You can check the request here:
[Confluence Server] we would like to be able to get statistics on usage [Confluence Cloud] we would like to be able to get statistics on usage
I see that you have also found the older version of this request, here in our Community:
[Atlassian Community] Track key metrics from Confluence Questions plugin
For you to get the desired data, we need to first look into the database organization itself. You can start by looking here:
[Confluence Server] Confluence Data Model
For you to find the tables needed for Questions for Confluence, I suggest that you compare your database before and after the installation of Questions for Confluence. What we want to do is compare two versions of your database, one before the installation of Questions for Confluence and one after the installation of Questions for Confluence.
You can take a look here to have an idea of how this works:
[StackOverflow] How to compare data between two databases in PostgreSQL? [StackOverflow] What is a free tool to compare two SQL Server Databases? [StackOverflow] Compare two MySQL databases [Ask Tom] Script to compare data in all tables in two different databases, if the table is present in both the databases.
The links above refer to each supported database for Confluence. Since this is not an Atlassian Supported procedure, the links are from outside Atlassian itself.
I hope this shines some light into your issue! Looking forward to your reply.
It looks like you're new here. Sign in or register to get started.
