JIRA Table Grid Editor issue picker

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

1 answer

1 accepted

0 votes
Accepted answer

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

This is a good start. I will play with the data a little more. Once I Select the project Item from the list, is there a way to capture the summary of that item into the table as well?

here is one of my attempts to also show the JIRA issue summary next to the pkey that was selected from the list. This does not display the value. Can you provided feedback if this approach is possible?

##################
# Grid properties
#
gd.columns = projectItem, psummary, commitment
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 jiraissue where project = 10304 order by pkey
col.projectItem.query.ds = jira
col.psummary = summary
col.psummary.editable = false

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

col.commitment = Commitment
col.dataPoint1.type = string

The only approach that I found that works, and this may not be a bad option is to concatenat the pkey and summary in the SQL Select. The benefit is that this does give a much more informative pull down.

col.projectItem.query = select pkey + ' - ' + summary from jiraissue where project = 10304 order by pkey

Correct - I did make a mistake in the column query.
The first attribute in the query is interpreted is the label showed in the select list, the second is the value. Both (label and value) are stored in the grid table.

So you are right
col.projectItem.query = select pkey + ' - ' + summary, id from jiraissue where project = 10304 order by pkey

Would show the user the pkey and summary and store this with the id in the attributes (projectitem_name, projectitem)

Additionally you can also use list values in other columns.

If you would have an additional column 'reporter' with following configuration

col.projectitem.query = select pkey + " - " + summmary, id, reporter from jiraissue ...

col.reporter = Reporter
col.reporter.type = string
col.reporter.formula = {projectitem.reporter}

the reporter column would get automatically the corresponding value.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

62 views 4 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you