How to integrate Jira server to Jira cloud using Boomi application

[anusha t]

How to integrate Jira server to Jira cloud using Boomi application. Please tell me the process.

[Mesut Yilmazyildirim]

It is not easy with JQL commands without writing new JQL function.

But you can query from DB via below SQL

SELECT p.pkey || '-' || i.issuenum AS jira_id,
 res_sum.Resolved_count Resolved_count
 FROM jirasd.jiraissue i,
 jirasd.project p,
 ( SELECT bl.issueid,
 SUM (CASE WHEN new_status LIKE 'Reopened' THEN 1 ELSE 0 END)
 Resolved_count
 FROM (SELECT cg.issueid,
 TO_CHAR (ci.newstring) new_status,
 TO_CHAR (ci.oldstring) old_status
 FROM jirasd.changeitem ci, jirasd.changegroup cg
 WHERE ci.field = 'status' AND ci.groupid = cg.id) bl
 WHERE bl.new_status IN ('Reopened')
 AND bl.old_status IN ('Resolved')
 GROUP BY bl.issueid) res_sum
 WHERE p.id = i.project AND res_sum.issueid = i.id