/
Test plan
Test plan
Introduction
The test plan with the list of issues. Grid shows status of each issue and helps deciding if it is worth to work on it.
Screenshots
Grid configuration
gd.columns=issuenum,status,decision
gd.tablename=issues
gd.ds=jira
col.issuenum=issuenum
col.issuenum.type=list
col.issuenum.query=select issuenum from jiraissue
col.issuenum.query.ds=jira
col.status=status
col.status.type=string
col.status.formula=queries:value('jira', 'select ist.pname from issuestatus ist inner join jiraissue ji on ji.issuestatus = ist.id and ji.issuenum = ' + {issuenum})
col.decision=decision
col.decision.type=string
col.decision.formula=if ('c2' =~ queries:list('jira', "select c.cname from component c inner join nodeassociation na on c.id = na.sink_node_id and na.sink_node_entity = 'Component' inner join jiraissue ji on ji.issuenum = " + {issuenum} + " and ji.id = na.source_node_id and na.source_node_entity = 'Issue'")) {'To process'} else {'Ignore'}
Related content
Issue type specific checklist
Issue type specific checklist
More like this
JQL search based on the content of the grid
JQL search based on the content of the grid
More like this
Using scripted fields to extract information from the grid (old)
Using scripted fields to extract information from the grid (old)
More like this
How to insert data into a grid table
How to insert data into a grid table
More like this
Exporting Table Grid data for multiple issues
Exporting Table Grid data for multiple issues
More like this
Version 1.3
More like this