Community
Products
Confluence
Questions
Sql query (sql server syntax) to return filesystem path for every attachment found in the confluence

Sql query (sql server syntax) to return filesystem path for every attachment found in the confluence

I found the following complex query for postgres:

But I need just a very simple query that could return the filesystem path for every attachment in the database.

1 answer

0 votes

There is no "simple" query. You have to derive the path from the raw data in table content and the rules in https://confluence.atlassian.com/doc/hierarchical-file-system-attachment-storage-704578486.html

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you Nic!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.