Skip to main content
Answer

Query how to extract Lucidchart diagrams from Confluence

  • February 8, 2024
  • 9 replies
  • 235 views

Forum|alt.badge.img+1

Hello Lucid Support,

I trust this email finds you well. I'm currently seeking to ascertain the page, space, and user associated with each Lucidchart diagram created in our Confluence Server instance.

Despite attempting SQL queries within the database, I've encountered difficulty in pinpointing these details accurately. Therefore, I'm reaching out to inquire if there's an alternative method or resource available to determine this information reliably.

Your guidance or assistance in this matter would be immensely helpful. If there are specific procedures or avenues I should explore further, please do not hesitate to inform me.

Thank you for your attention to this request.

Best regards,

Best answer by Phillip W

Hey @Amani -- thank you for the reply and clarity! After checking with our internal teams, if you search for macroName:lucidchart, that should pull up all pages with Lucidchart macros on them. 

Let me know if this helps!

 

Comments

Phillip W
Forum|alt.badge.img+16
  • Lucid support team
  • February 12, 2024

Hey @Amani -- thanks for posting! So what you’re currently asking for is NOT built into the Lucid plugin. What are you exactly are you trying to achieve here?


Forum|alt.badge.img+1
  • Author
  • February 12, 2024

Hello Philip,

 

Thank you for your reply. 

As we proceed with the migration from Confluence Server to Confluence Data Center, one crucial aspect involves transferring our Lucidchart diagrams to the Draw.io plugin. However, despite our efforts, locating these Lucidchart diagrams within the database has proven to be challenging.

Our goal is to identify the exact location of each Lucidchart diagram, including the associated page, space, and the user who created it. This information is essential for ensuring a smooth transition and enabling each user to migrate their own diagrams to the new instance.

Given that we have over 1000 diagrams to migrate, we need everyone's assistance in this process. If you have created or used Lucidchart diagrams within our Confluence Server instance, we kindly request your cooperation in identifying them and providing the necessary details.

 

Regards,

Amani


Phillip W
Forum|alt.badge.img+16
  • Lucid support team
  • Answer
  • February 14, 2024

Hey @Amani -- thank you for the reply and clarity! After checking with our internal teams, if you search for macroName:lucidchart, that should pull up all pages with Lucidchart macros on them. 

Let me know if this helps!

 


Forum|alt.badge.img+1
  • Author
  • February 14, 2024

Hello @Phillip W 

Thank you for your feedback. I appreciate your request for further details regarding macroName:lucidchart, the specific table where I should conduct the search. Below, you'll find all the CONTENTTYPE entries we have in our ATTACHMENTS_BACKUP table. Additionally, I've included the Confluence content type for Lucid diagrams in our Confluence’s instance : application/vnd.lucid.confluence-onprem; minorEdit=false.

 

Regards


Phillip W
Forum|alt.badge.img+16
  • Lucid support team
  • February 15, 2024

Hey @Amani -- thank you for the reply! Sorry about the confusion, I maybe should have been more clear. macroName:lucidchart is not a table name, it's a search query you have to use in Confluence's search feature.

However, based on the details in your last message, it sounds like you’re using Lucidchart OnPrem (which we no longer support) instead of the Lucidchart Diagrams Connector (which we do support). In this case, you’ll want to use macroName:lucidchart-onprem

Hope this helps!


Forum|alt.badge.img+1

Sadly, in Oct 2025 this no longer appears to work as Atlassian have broken the ability to search in Confluence, again. 


Leianne C
Forum|alt.badge.img+15
  • Lucid support team
  • October 21, 2025

Hi ​@Neil Brennan, thank you for continuing this thread. Would you mind sharing a brief description of what you see when trying to search using macroName:lucidchart to pull all the pages wth Lucidchart macros? This information will help our team take a closer look at this. Thank you!


Forum|alt.badge.img+1

No problem.

It looks like Atlassian have removed the capability you recommend from their search, so when we search for `macroName:lucidchart`  we now see the 3 pages in our org that have the word `macroName` on them. Not particularly helpful. None of these pages have a lucid diagram on them.

Searching on `lucidchart` returns only the pages where we have discussed issues with lucid charts. :) 


Leianne C
Forum|alt.badge.img+15
  • Lucid support team
  • November 11, 2025

Hi ​@Neil Brennan, our engineers confirmed that searching via macroName:lucidchart is still possible in Confluence Data Center instances. Please let us know if you are still experiencing issues with this and we would be happy to take a closer look. Thanks!