Query to display Initiatives that are linked with Epics that have additional criteria

[Gregory Kremer]

Hi all, 

Could someone please assist me with a query that would grab Initiatives that have Epics with Field1 = ABC and Field2 = XYZ ?

I would greatly appreciate prompt assistance. And yes, we have ScriptRunner installed.

Again, thank you in advance for your help.

As @Trudy Claspill and I were trying to figure out what I am doing wrong and so far couldn't, is there someone from Adaptavist who would be able to help in resolving my problem? I'd greatly appreciate it.

[Jobin Kuruvilla [Adaptavist]]

Are you talking about BMC Remedy? Our integration platform, ConnectAll, already has adapters for JIRA and Remedy.

See https://www.connectall.com/integration/adapters/bmc-remedy/

You might want to request an evaluation to see if that works. On top of it, you can create custom adapters for internal applications if you want to connect to applications that are already listed under adapters.

[Alexey Matveev]

Hello,

If you want to integrate Remedy and Jira through email, then you can not do much with of the box mail handlers. For example, you can not change the status of an issue on getting a email. You should use such plugins as Email this issue or Jira Enterprise Email Handler.

But I think it would be a better solution to integrate Remedy and Jira via Jira Rest Api. You can find more info here:

https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/?_ga=2.6605170.1504307142.1529525766-978693878.1529525766