1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| create procedure jtest()
begin
declare v_idproj decimal(18,0);
declare v_req text;
declare v_pname varchar(255);
select id into v_idproj from project where pname="Proj";
set v_req = " <?xml version='1.0' encoding='UTF-8'?>
<searchrequest name='v_pname'>
<parameter class='com.atlassian.jira.issue.search.parameters.lucene.ProjectParameter'>
<projid andQuery='false'>
<value>v_idproj</value>
</projid>
</parameter>
<sort class='com.atlassian.jira.issue.search.SearchSort'>
<searchSort field='issuekey' order='DESC'/>
</sort>
</searchrequest>";
insert into searchrequest values (10315,"Proj","User","Issues","user","NULL",10005,v_req);
End |
Partager