Versions Compared

Old Version 7

changes.mady.by.user Smita Nair

Saved on

compared with

New Version Current

changes.mady.by.user Praveena Manohar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article applies only to the Data Center version of the LaTeX Math app

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

Instructions

  1. Log in as Confluence administrator and navigate to Cog click the Gear icon > General configuration > Administration > Macro Usage:

screenshot-1 (1).pngImage Modifiedscreenshot-2 (1).pngImage Modified

  1. Under All macros, look out for the 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 key, space name, and titleof the relevant pages.

Code Block
languagesql
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. Check the 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.

  • Query syntax has to be adjusted depending on the database used.