Where exactly is the data of Questions for Confluence stored in the DB?

freitel_mobile June 11, 2018

I found different suggestions for this so far. Some Page claimed that it is stored in a Questions space (which I can't find) another Page said it is stored in the CONTENT Table under a plugin key. There too I can't find anything which refers to questions.

Also the AO Tables seem to be misleading.

The documentation is lacking this information as well.

We are on the evaluation and this question where it stores the data is quite crucial for us. 

Please give me a hint if you have more insight.

2 comments

Comment

Log in or Sign up to comment
Danyal Iqbal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 11, 2018

We are on the evaluation and this question where it stores the data is quite crucial for us. 

 

I dont see any reason why this info is crucial for you. Please explain your use case.

It is stored in the database. 

freitel_mobile June 11, 2018

For us it is a crucial point to being able to keep the data even if the eval has the outcome that this questions is not the correct solution for out purposes.

Can you point me to the tables where the data is stored?

Hubert Kut
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 12, 2018

Hi Frank,

The Q&A stores data in following tables:
- AO_B1DBB9_ACCEPTANCE   
- AO_B1DBB9_BOUNTY
- AO_B1DBB9_VOTE
- CONTENT
- BODYCONTENT


All question can be found using that query:

SELECT * FROM %YOURCONFLUENCEDBNAME%.CONTENT
where PLUGINKEY in
('com.atlassian.confluence.plugins.confluence-questions:question)

All answers can be fetched using this query:

SELECT * FROM %YOURCONFLUENCEDBNAME%.BODYCONTENT b
where b.CONTENTID in (
SELECT a.CONTENTID FROM %YOURCONFLUENCEDBNAME%.CONTENT a
where a.PLUGINKEY in
('com.atlassian.confluence.plugins.confluence-questions:answer'
))

Like # people like this
freitel_mobile June 13, 2018

Hi Hubert,

 

thanks a lot!! That is the answer I needed.

Gary Pasquale
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 14, 2018

Very useful. Thanks.

TAGS
AUG Leaders

Atlassian Community Events