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'}