Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Database Query

profile-name	SQL jira
refresh-button	true
profile	8619700
bounding-box	true

SELECT 

issuenum, issuetype, summary, customfieldvalue.stringvalue, issuestatus.pname

FROM 

jiraissue

JOIN issuestatus ON issuestatus.id=jiraissue.issuestatus
JOIN customfieldvalue ON jiraissue.id = customfieldvalue.issue where customfield=(select ID from customfield where cfname='Назва майданчика')

AND

project = (select id from project where pkey='SBM')

...