retrieving attachments from mantis database(postgresql) session

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
bpabla50
Posts: 5
Joined: 09 Feb 2023, 19:29

retrieving attachments from mantis database(postgresql) session

Post 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.
cas
Posts: 1581
Joined: 11 Mar 2006, 16:08
Contact:

Re: retrieving attachments from mantis database(postgresql) session

Post 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:
Post Reply