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
issuenum, 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')

...