Page Comparison

...

This article helps you find all the spaces and pages where the Latex LaTeX Math for Confluence macros are added to your Confluence instance hosted on the Data Center.

Instructions

1. Log in as Confluence

...

1. administrator and navigate to 

...

1. Cog icon > General configuration > Administration > Macro Usage:

Image Added

...

Image Modified

2. Under All macros, look out for the

...

2. app name Latex Math:

...

Usage information using SQL queries

Use the following query to get the macro-level usage information. If the query returns any records, the output includes the Space Keythe space key, Space space name, Title and titleof the relevant pages.

SELECT DISTINCT SPACES.SPACEKEY, SPACES.SPACENAME, CONTENT.Title, BODYCONTENT.body FROM BODYCONTENT
JOIN CONTENT ON BODYCONTENT.CONTENTID = CONTENT.CONTENTID
JOIN SPACES ON CONTENT.SPACEID = SPACES.SPACEID
WHERE BODYCONTENT.BODY like '%<ac:structured-macro ac:name="mathblock"%'
 OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathblock-ref"%'
OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathinline"%'
OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="mathblock-table"%'
OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="unit"%'
OR BODYCONTENT.BODY LIKE '%<ac:structured-macro ac:name="latex"%'

Results

...

...

Info
It is recommended to:  Test the above queries in a test environment. The Check the time taken to get the results is based on the number of pages where the macro is used. Run the query during off-business hours to reduce any impact caused by the query's run time. Queries have Query syntax has to be adjusted with syntax in databasesdepending on database used.