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