Skip to main content

How to retrieve versions of an Excellentable from Confluence database


An example Excellentable with multiple versions



The table in Confluence database to store Excellentable versions


AO_40ABA8_EDIT_HISTORY_DB


In the above table schema, the TABLE_DBID column is the foreign key which identifies unique Excellentable.

SQL query to retrieve versions of an Excellentable from Confluence database


CODE
select "ID", "TABLE_DBID", "ACTION", "COMMENT", "CREATED", "CREATOR" from "AO_40ABA8_EDIT_HISTORY_DB" where "TABLE_DBID"=<Excellentable_ID>;


You can get the Excellentable_ID for your Excellentable by using inspection tools in your browser.

For Example, in Chrome browser, you can right click on Edit button of your Excellentable in view mode of Confluence page and then click "Inspect" option to get the value of "excellentable-id" property from the resulting HTML code view for the page. Please see below for your reference:


Results of versions retrieved for the example Excellentable from Confluence database 


SQL Query used

CODE
select "ID", "TABLE_DBID", "ACTION", "COMMENT", "CREATED", "CREATOR" from "AO_40ABA8_EDIT_HISTORY_DB" where "TABLE_DBID"=235080;


Query Output



Conclusion

  1. In general, if versions of an Excellentable shown under "Edit History" on Excellentable UI are not similar to the versions retrieved from the Confluence database, please raise a bug with Excellentable Support.
  2. If some Excellentable versions do not exist in the database, they were probably not saved by the user.


If Excellentable Collaborative editing is enabled, and a user edits an Excellentable to make changes, the changes will always be displayed in Excellentable UI when the user opens the Excellentable next time, but those changes are temporary until Collaborative editing cache is cleared.

The changes will only be saved into Confluence database when the user saves them manually from Excellentable UI.

The unsaved changes will be lost when we clean up Collaborative editing cache.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.