Hey,
What I'm trying to do is create an automation that does the following:
- Upon being triggered by a ticket being closed, checks to see if there are any fix versions attached to the ticket.
- Grabs the names of all versions in the fix version field on the trigger ticket.
- Checks each version listed to see if there are any remaining open tickets.
- If no remaining tickets, release the version.
I had this working when there was 1 version in the fix version field, but as I'm learning, the users are having multiple versions and now I can't get the branching and array working to have each version checked in steps 3 and 4 (if applicable).
This is one of the lookup queries I've tried for step 2.
fixversion in ( {{triggerissue.fixVersions.name.asJsonString.asJsonArray}} ) AND statuscategory NOT IN (Done)
Does anyone have any suggestions on how I can accomplish this? I am running in to the wall here.
Thank you!