Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

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 queryformulas 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.

  • No labels