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:
I see that you have also found the older version of this request, here in our Community:
For you to get the desired data, we need to first look into the database organization itself. You can start by looking here:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.