JIRA Table Grid Editor issue picker

David Frager _gmail_

Is it possible to use the Table Grid custom Field, and have one of the columns contain a list of JIRA issues from another project, but be selectable and validated via an issue picker query?

I realize that I can manually enter each of the issues into the table, but I would like to have some type of validation and picker capability to assist with data entry

I have a project to store Customer Initiatives (CI). Within each project, I would like to have a table that has Project Items (PI), along with some specific data on each item, as it related to this specific customer initiative. The data is related to the *linkage* between the CI and the PI and not specific CI or PI item. An example would be:

CI-1

Project Item Data Point 1 Data Point 2

PI-1 U 10

PI-2 C 8

CI-2

PI-1 C 5

PI-3 U 8

francis

Hi David,

This is certainly possible using a column query in your grid table definition.

Your grid configuration would be something like

##################
# Grid properties
#
gd.columns = projectItem, dataPoint1, dataPoint2
gd.tablename = projectItems
gd.ds = jira


##################
# Define the projectItem column as a list column
# initialized with a particular set of project items
# Assume the project with project items has id 10002
# and also assume JIRA 5, as the project key in JIRA 6 is 
# calculated differently
#

col.projectItem			 =	Project Item
col.projectItem.type	         =	list
col.projectItem.query	 = 	select pkey, summary from jiraissues where project = 10002 order by pkey
col.projectItem.query.ds   =     jira


######################
# Define the other columns

col.dataPoint1 			 = Data Point 1
col.dataPoint1.type		 = string


col.dataPoint2 			 = Data Point 2
col.dataPoint2.type		 = string