CAUTION: heavy queries (e.g. multiple joins) could cause crashes!
...
| No Format |
|---|
select
p.pkey||'-'||i.issuenum as "KEY",
ci.field,
cg.created as Modified,
dbms_lob.substr(ci.oldstring, 4000, 1) as OLD_String,
dbms_lob.substr(ci.newstring, 4000, 1) as NEW_String,
dbms_lob.substr(ci.oldvalue, 4000, 1) as OLD_Value,
dbms_lob.substr(ci.newvalue, 4000, 1) as NEW_Value
ci.id as Change_Item_Id
from changeitem ci
join changegroup cg on
ci.groupid = cg.id
join jiraissue i on
cg.issueid = i.id
join project p on i.project = p.id
where p.pkey||'-'||I.issuenum in ('TEST-106') |
...and to update an item that gets returned:
| No Format |
|---|
UPDATE changeitem
SET OldString = 'Set Text Here'
where changeitem.id = 1819534 |
Return saved filters that contain the text In Post LC
...
- Copy the desired column out of excel and paste directly into Word.
- In Word, press Ctrl+H (find and replace). Find ^p and replace with ,
| No Format |
|---|
SELECT p.pkey||'-'||I.issuenum as "KEY",summary,created,updated,reporter,creator
FROM JIRAISSUE i
JOIN project p ON I.project=p.id
WHERE
p.pkey||'-'||I.issuenum in
('PICO-5910','KIT-98') |
...