Archives for: May 2012, 14

Handy SQL

May 14th, 2012

Created this SQL-statement used for one of our JIRA-instances. Needed to get rid of a lot of open sub-tasks where the parent task had been cancelled. The statement also shows usage of inner join and self-join.

Code:

U PDATE jiraissue ji1, jiraissue ji2
INNER JOIN issuelink il
SET ji1.resolution = 9, ji1.issuestatus = 6
WHERE ji1.resolution  IS NULL
AND ji1.id = il.destination
AND ji1.issuestatus = 1
AND il.source = ji2.id
AND ji2.resolution = 9;

Posted in Work/Geek | Send feedback »

Todays view

May 14th, 2012

Today having this view while working.

Not a local? Mosjøen

Posted in Anything but the other | Send feedback »