jira attachment

[Padmasree P]

where is the Jira attachment url details stored in Jira db. is there any table where we can get the attachment urls

[Pedro Felgueiras]

Hy @Padmasree P

You have the table fileattachment. 

with that you can construct url with {Jira URL}/secure/attachment/{id}/{filename}

I hope it help. 

Best regards, 

Pedro Felgueiras

[Yanet Morales]

This was helpful in my findings to trying a workaround to include attached images in a file exported using an Xporter template, but unfortunately it didn't resolve my problem

[Nic Brough -Adaptavist-]

The attachments table is what you need to read, but there's no url or path stored.  There is data that will enable code to work out where the file is on the disk.

I think we need to know why you are looking for a "url" when there isn't one.

[Padmasree P]

Hi Nic,

we migrated our Jira server to a different server and changed the dns name in new server..after dns name change , Jira base url is updated to the new dns name.jira issues, attachments are fine after migration.

but there are attachments which are in issue comments , which is still pointing(fully qualified hyperlinks) the old url/dns of Jira. how do I get this updated to new url

[Nic Brough -Adaptavist-]

You will have to edit the comments.  It's nothing to do with the attachments themselves, your users have put urls in as part of the comment.

[Padmasree P]

hi Nic,

user did not hardcode the url in comment. he has attached an excel file in old jira server. attachment hyperlink is still pointing to the old dns name. how do we edit the old hyperlinks to the new dns name.

[Joe Pitt]

The location is stored in settings. There may not be a url that can access the location. Why not just ask the JIRA admin where they are? 

[Padmasree P]

hi Joseph,

I'm not asking the attachment location. whenever user is uploading attachment, is there anywhere in db the attachment details are stored like direct url of attachment.

I migrated Jira to a different server and changed the dns in new server and updated the base url in new server. the migrated environment is fine with attachments and users are able to download it.

but when checked the attachment which are in comment section of the issue. it is still pointing to the old url/dns name. not sure how to get this updated. any help would be appreciated.

[Joe Pitt]

What did you do with the attachments? At some places I've worked the application is on one server and the DB and attachments are on another one. The settings could be pointing to the old location. If you didn't update the settings for attachments they are probably still there. The user wouldn't see any change in function. If you copied the attachments but didn't update the settings the users will be using the old location.