Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to get the TYPE information for every issue being raised, like Task or Incident

CLSA CorporateApplication June 24, 2019

I would like to include the TYPE of ISSUE information to my existing query:

Existing query:-

select ji.PKEY,i.pname,c.cname, l.label, ji.SUMMARY,ji.ASSIGNEE,ji.REPORTER,ji.DESCRIPTION,ji.ENVIRONMENT,ji.PRIORITY,ji.CREATED,ji.DUEDATE,ji.UPDATED,ji.RESOLUTIONDATE
from issuestatus i, project jp, jiraissue ji, component c, nodeassociation na, label l
where 
i.id=ji.issuestatus 
and
ji.project = (select id from project where pkey='IG') and 
jp.id = ji.project
and na.source_node_entity = 'Issue'
and na.sink_node_entity = 'Component'
and na.source_node_id = ji.id
and c.id = na.sink_node_id
and ji.id=l.issue
and jp.pkey='IG';

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events