How to find out matching attachment Id and filename?

Question

Jira stores all attachments not with the filename in the attachment but as an ID.

Now I have to find out which ID belongs to a specific filename.

The only way to do this in my opinion is to query the database .

I do not know which table I have to query. Maybe attachment .

There I should find the matching of Id and filename.

Has anyone done this before ?

Nic Brough -Adaptavist- · Accepted Answer

You either need to read the database or code for asking the API for the id of any given attachment.

I'd question why you think you need this though - the attachment ID doesn't tell you anything you would need to know that you can't get by reading the issue the attachment is attached to (and you'll get the name of the file if you go via the issue)