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 SQL LaTeX Math for Confluence macros are added to your Confluence instance hosted on the Server or Data Center.
Instructions
Log in as Confluence
...
administrator and click the Gear icon > General configuration > Administration > Macro Usage:
...
.png?version=2&modificationDate=1716388164039&cacheVersion=1&api=v2&width=360) | .png?version=2&modificationDate=1716388177374&cacheVersion=1&api=v2&width=217) |
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 Title the space key, space name, and titleof the page and SpaceID of the relevant pages.
For the SQL macro, execute the following query:
| Code Block | ||
|---|---|---|
|
...
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"%' |
...
For the SQL-query macro, execute the following query:
...
| language | sql |
|---|
...
|
...
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"%' |
...
For the SQL file macro, execute the following query:
...
| language | sql |
|---|
...
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:
|