...
Audience: JIRA admins and other users that have access to the an on-prem JIRA production db.
This page contains a non-exhaustive list of SQL queries that can be done from JIRAfor an on-prem Jira instance. For other examples provided by Atlassian, see Information link below the list.
...
Code Block |
---|
SELECT * FROM customfield WHERE customfield.customfieldtypekey LIKE 'org.broadinstitute%' ORDER BY customfield.customfieldtypekey |
Return comments, summary, descriptions containing certain textÂ
text e.g. tableau-sap
Code Block |
---|
select p.pkey||'-'||j.issuenum as key,a.actionbody,j.summary,j.description from jiraaction a join jiraissue j on a.issueid = j.id join project p on j.project = p.id where a.actionbody like '%tableau%Tableau-sap%' OR j.summary like '%Tableau-sap%' OR j.description like '%Tableau-sap%' |