...
| 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%' |