Where can we get the attachments under Zephyr test case executions

[Mani]

Hello,

Under Zephyr test executions when you click on E under actions it goes to another page where the users are attaching the attachments to the executions.

Under which table the attachments are stored with the corresponding name. We need to display in the report whether attachment exists or not for the test executions.

Thanks,

Raju

[Neelakanta Reddy M]

Hey,

Zephyr stores the file name and file path info in ao_7deabf_attachment table and this store attachment info only for Execution and Step Result. 

Regards

Neelakanta

[Kai Becker]

Hi @Neelakanta Reddy M 

do you know, where the real file is stored? The database table has no reference to a path.

[Neelakanta Reddy M]

Hi @Kai Becker 

The files are stored in jira shared directory in datacenter or jira home directory in server. 

Path to the files are on project basis.

shared directory/data/attachments/projectkey/schedule/testexecution id/attachment id

Hope this helps!!

Regards

Neelakanta