Page 1 of 1

retrieving attachments from mantis database(postgresql) session

Posted: 20 Mar 2023, 14:51
by bpabla50
Hi :
Since I am not able to export some information to CSV file e.g. attachments, relationship table etc. I am wondering, can these be retrived using SQL commands of postgresql database.
I am logged into database session, how the syntax of SELECT will look like , if I want to a) retrieve all attachments of a given issue b) retrieve all attachments for the whole project covering every issue of that project?
Any advice? Thanks.

Re: retrieving attachments from mantis database(postgresql) session

Posted: 20 Mar 2023, 16:02
by cas
well if you an access the database with a tool, you can retrieve a lot of info but you need to study the database scheme of mantis to get a coherent set of data. Other way can be to create a few scripts using Mantis functions to achieve what you want. It is not available out of the box :mrgreen: