IS there a way to access issue id in sql query

[Surya Sonal Saripalli]

I am trying to use nfeed field to pull information to populate a field called as comments that changes based on the current transition ticket. I would like my sql query to access the issue id to know the current transition state, Is there a way to access issue id in sql query?

[Mesut Yilmazyildirim]

Is this what you are looking for?

select i.id,
 p.pkey||'-' ||i.issuenum as jira_id,
 it.pname issue_type,
 s.pname last_status,
 i.summary summary 
from jirasd.jiraissue i,
 jirasd.project p,
 jirasd.issuetype it,
 jirasd.issuestatus s
where p.id = i.project
and it.id = i.issuetype
and i.issuestatus = s.id

[Surya Sonal Saripalli]

thank you