attachment confluence content

Question

Dear Support Team, 
Would it be possible to use sql language to find out attachments list in some space? We use as listed as below:
select * from attachments where pageid in (select pageid from content where spaceid='12288001')

But some attachments are not shown in the result.

Hsu Yao Chang · Answer

We wish to use sql language to find out attachment list in some space as listed as below select * from attachments where pageid in (select pageid from content where spaceid='12288001')

I have ever try attachments macro , but it just can list the attachment in the page, not all attachments in the space.

Thanks a lot.

Rodney Hughes · Answer

Not sure what the context is of your request, but ... why not just insert the "Attachments" macro in the main body of the page Edit Mode then <> and select <>