Page Comparison

This article helps you get find all the list of pages where the Advanced Tables SQL for Confluence macros are added to your confluence Confluence instance hosted on the server Server or data centerData Center.

Instructions

Option 1:

• Log in as Confluence Administrator and navigate to 

...

• Cogwheel > General configuration > Administration > Macro Usage:

Image Removed

...

• Under All macros, look out for the App name

...

• SQL(Pro Edition) for Confluence:

...

Option 2:

Usage information using SQL queries:

As the Advanced Tables the SQL for Confluence has five three macros, you must execute the query must be executed for each macro to get the macro-level usage information. If the query returns any records, the output includes the the Title of the page and SpaceID of  and SpaceID of the relevant pages.

...

• For the

  json-table

  SQL macro, execute the following query:

  Code Block
  language sql theme Midnight
  Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="json-tablesql"%');

  For the table-plus macro, execute the following query:
  

  Code Block
  language sql theme Midnight
  Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="table-plus"%');

  For the jql-table

  
  Results:

  Image Added

  
  

• For the SQL-query macro, execute the following query:

  Code Block
  language sql theme Midnight
  Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="jqlsql-tablequery"%');

  For the attachment-table macro, execute the following query:
  

  Code Block
  language sql theme Midnight
  Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="attachment-table"%');

  For the CSV

  
  Results:

  Image Added

• For the SQL file macro, execute the following query:

  Code Block
  language sql theme Midnight
  Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST') AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="csvsql-file"%');

...

• Results:

  Image Added