Sales list

Owned by svitlana (Deactivated)
Last updated: Jul 04, 2018
1 min read

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.