Try ERPNext Buy Support Partners Foundation

Query Report with Link to File

Hi,

I would like to know if it possible to build a Query Report with a Link to an attached file.

Basically, my idea is to have a custom DocType, let’s say Dummy:

Dummy: 
   + name: Data
   + document: Attach

I would like to build a query report like this:

SELECT
    d.name AS "Title", 
    d.document AS "Document:Link/File"
FROM `tabDummy` AS d

The idea is that the user would be able to see all data and open specific attachments directly from the report.
The previous query is just an example of the idea. I know I could (probably) achieve this by making the document field displayable in the Listing, but the real use case I have requires to join several tables, hence the need to use a Report.