Can I use object NOT HAVING connectedTickets in a iqlFunction

Question

Hi,

In an automation rule I want to use a JQL that checks for request type and also whether an InsightObject is linked to open issues.

Does anyone know if (and how) I can use the following IQL in an iqlfunction?

object NOT HAVING connectedTickets(project = IPA AND issuetype In (Epic,Action)

So something like:

“Request Type” in (“Request OTA (IPA)“,”Request/change PA account (IPA)“) AND cf[15203] in iqlFunction(“\”object NOT HAVING connectedTickets(project = IPA AND issuetype In (Epic, Action)“)

But this one gives IQL in iqlFunction is not valid.

Anyone have a good idea?

Regards, Marco Brundel

Marco Brundel · Accepted Answer

Hi,

My colleague @Stefan Krooshof  helped me with the correct syntax"Request Type" in ("Aanvraag OTA (IPA)","Aanvraag/wijzigen PA account (IPA)") AND cf[15203] in iqlFunction("object NOT HAVING connectedTickets(project = IPA AND issuetype In (Epic,Action))")

Regards,

Marco

Stefan Krooshof_599zfs · Accepted Answer

Also note that if you want to replace the JQL in connectedTickets() with something that should be in quotation marks itself, like "Request Type", you should use single quotations marks here.

Example:

"Request Type" in ("Aanvraag OTA (IPA)","Aanvraag/wijzigen PA account (IPA)") AND cf[15203] in iqlFunction("object NOT HAVING connectedTickets('Request Type' in IPA AND ('Aanvraag OTA (IPA)'))")

Marco Brundel · Accepted Answer

Unfortunately, the JQL does work to find issues, only the a4j-rule does not respond to the JQL.

The rule returns "The following issues did not match the condition:"

While the issue on which the rule gives this message is found with the filter.

Cause found: The actor did not have permission on Insight. The actor has been given the permission 'object schema users' and the automation rule works like a charm.