Can I use object NOT HAVING connectedTickets in a iqlFunction

[Marco Brundel]

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

[Stefan Krooshof · Accepted solution]

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 solution]

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

[Marco Brundel · Accepted solution]

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.