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

Where are tables stored in Confluence database

Hi all,

Do you know in what table in the Database are tables from a Confluence page saved? 

I would need to find a list of all tables in Confluence database, and I am not sure how they are handled in the DB.

Thank you in advance.

Kind regards,

Eva

3 answers

2 votes
Dominic Lagger Community Leader Feb 27, 2019

Hi,

A table in a confluence site is not a table in the confluence database. 

The content of a site is stored in the bodycontent table. There you have the attribute body, which contains the content in the confluence storage format

You can take out all content pages with tables in it with this SQL:

Select * from Bodycontent b where b.body like '%<table>%'
1 vote

Bodycontent, but see https://confluence.atlassian.com/doc/confluence-data-model-127369837.html for most (not quite all) table definitions.

0 votes

Bodycontent, because the tables are part of the page, and that's where pages are stored.  They're not separate from the rest of the page, just encoded.

See https://confluence.atlassian.com/doc/confluence-data-model-127369837.html for most of the rest of the Confluence tables.

I'd strongly recommend staying away from the database though, it's almost certainly the worst possible way to achieve whatever you are trying to do.  If you could explain what you're trying to do, we might be able to get you a better way to do it.

We need to figure out if an add-on - xTables - related to Tables is used/not. We wanted to find information in the database, as macro usage under Confluence administration is not showing the data.

I need to find all the pages/users who used xTables in Confluence. 

Hmm.  That depends entirely on how xTables stores its data in Confluence. 

If it's using added macros (so your users do something like "content {xtables macro} more content), then a simple search for the macros will be able to find usage.

If it's storing it some other way, you'll need to analyse how the app works to find out how its doing it.  I don't know the app, so I can't help you with that bit.

@Eva Dezsi  Where you able to solved this? I have the same situation.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

146 views 0 5
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