Exact search for an attachment using the attachment name in Java

[Tuelle]

Hi, 

I want to check (in Java) if an attachment with a given filename already exists in my entire Confluence system. I was able to perform a V2 search and limit the results by ContentType, but how can query for a specific attachment name? What type of Query Object do I have to use and how would the constructor look like?

Thanks

Thorstne 

[AnnWorley]

If you just need to know if the attachment exists in the instance you can query the database with a query like this, which worked on my PostgreSQL db:

select * from content where contenttype = 'ATTACHMENT' and title = '<filename_case_sensitive>';

If you need to do it in Java because of a solution you are building then we will have to defer to the more Java savvy members of the Community.