Jira : Dragging issues direct from the (Oracle) db

col c1 format a900 set lines 2000 pages 0 head off long 2000 longchunksize 2000 wrap on trimspool on trim on with base_data as ( select i.id iid, -1 aid, to_char('######### '||i.pkey ||' - '||i.assignee ||' - '||i.summary || ' #########') c1 from jira_dbo.jiraissue i where 1=1 and i.assignee like 'data%' union all select i.id iid, 0 aid, to_char(substr(i.DESCRIPTION,0,1000)) c1 from jira_dbo.jiraissue i where 1=1 and i.assignee like 'data%' union all select i.id, a.id, to_char(substr(a.ACTIONBODY,0,1000)) c1 from  jira_dbo.JIRAISSUE i, jira_dbo.jiraaction a where 1=1 and a.issueid = i.id and i.assignee like 'data%' ) select c1 from base_data  order by iid,aid