How to configure a file list picker

Introduction

If you want to configure a drop down box containing all the issues of the containing issue.

Solution

This step is very simple - just add a column with following configuration

#
# Define a column which will contain the filename
#
gd.columns = filename
gd.tablename = files
gd.ds = igridtest

#
# This column is a dropdown list, initialized from the list of attachments linked to the issue
#
col.filename = Filename
col.filename.type = list
col.filename.query = select filename, id from fileattachment where issueid = {0}
col.filename.query.parameters = issue:id
col.filename.query.ds = jira