Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

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

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

Danyal Iqbal Community Leader Jun 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. 

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 Jun 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

Hi Hubert,

 

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

Very useful. Thanks.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Data Center

Introducing Data Center Community licenses

I'm Alison Huselid, Head of Product for Data Center at Atlassian. As we shared in our last post, we’ve been working on a solution for those of you who work for charitable non-profit organizations tha...

591 views 9 37
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you