Introduction
As head of Sales department you create a report with sales receipts attached
Screenshots
Grid configuration
This configuration makes use of such features of TGE as list query, formulas and wiki renderer
Note that thanks to the wiki renderer feature you don't even need to create the url for the attachment yourself, you only need the file name.
gd.columns=product,quantity,receipt,receipt_link
gd.tablename=attachments
gd.ds=jira
col.product=Product
col.product.ty=string
col.quantity=Quantity
col.quantity.type=integer
col.receipt=Receipt
col.receipt.type=list
col.receipt.query=SELECT FileName, ID FROM fileattachment WHERE issueid={issue:id} ORDER BY FILENAME DESC
col.receipt.query.ds=jira
col.receipt_link=Receipt link
col.receipt_link.type=string
col.receipt_link.renderer=wiki
col.receipt_link.formula='[^' + {receipt.name} + ']'
SQL Setup
Not necessary
Usage
With this grid configuration you will be able to select any of issues' file attachments in the grid and have links to those attachments directly in the grid itself.