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