...
| Code Block |
|---|
SELECT
*
FROM
customfield
WHERE
customfield.customfieldtypekey LIKE 'org.broadinstitute%'
ORDER BY
customfield.customfieldtypekey |
Return comments containing certain textÂ
text e.g. tableau-sap
| Code Block |
|---|
select p.pkey||'-'||j.issuenum as key,a.actionbody
from jiraaction a
join jiraissue j on a.issueid = j.id
join project p on j.project = p.id
where a.actionbody like '%tableau-sap%' |