...
Return changeitems (including before and after values, as well as modification date) for issue TEST-106
| 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') |
| Code Block | ||
|---|---|---|
| ||
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 Formatcode | ||
|---|---|---|
| ||
UPDATE changeitem SET OldString = 'Set Text Here' where changeitem.id = 1819534 |
...
Return saved filters that contain the text In Post LC
| Code Block | |
|---|---|
| |
| |
SELECT a.id, a.filtername, dbms_lob.substr(a.reqcontent, 4000, 1 ) as JQL, a.authorname FROM searchrequest a WHERE dbms_lob.substr(a.reqcontent, 4000, 1 ) like '%In Post LC%' |
...
Return agile boards that have a swimlane with JQL query containing Nexome
| No Formatcode | ||
|---|---|---|
| ||
SELECT a.name AS as Swimlane_Name, r.name as Board_Name, r.owner_user_name as Owner, a.query FROM ao_60db71_swimlane a JOIN ao_60db71_rapidview r on a.rapid_view_id = r.id WHERE a.query LIKE '%Nexome%' |
...