I'm trying to bulk unexalate several Jira issues, could anyone help me achive this?

I need to bulk unexalate several jira cards but before unexalate them I need to know the ServiceNow ticket number related to that card, how can I achive this two things?

Hi @Juan_Manuel_Alarcon,

Why do you need to know the ServiceNow ticket number before unexalating the Jira issues? Are you trying to create a list of connected issue pairs between ServiceNow and Jira before disconnecting them?

For bulk unexalate operation, the idea is simply to first group the issues you want to disconnect using a trigger with a JQL filter. Once that trigger identifies the relevant issues, Exalate gives you the option to unexalate all of them at once directly from the trigger view via the three-dot menu.

Documentation: Bulk Unexalate Operation | Exalate Classic

Hi Javier, Im trying to get the Servicenow ticket because those tickets need to be cancelled as tehy won’t be worked on. also, could you provide an example of the JQL filter, just to make sure I get it correctly

Hi @Juan_Manuel_Alarcon,

If the ServiceNow tickets need to be cancelled before disconnecting them, the first step would be identifying all the Jira issues that need to be disconected

Do those Jira issues have something in common? If so, you can use that in a JQL query. For example:

project = ABC AND labels = "cancel-request"

Another option would be to automate the process through the Exalate script.

For example, you could:

  1. Add a specific label to the Jira issues that should be unexalated (for example, cancel-sn-ticket).
  2. In the incoming sync of SNOW, transition the ticket to a Cancelled state.
  3. Use Exalate’s unExalateAfterProcessing() feature to automatically disconnect the issue pair once the cancellation has been processe if replica.lables contains cancel-sn-ticket