Make <> Jira | Help with JQL Query

How To
1

Hey guys.
I hope you are well.

I created a connection between Make and Jira and I need help to correctly parameterize a JQL Query. The objective is to search for issues that meet a certain requirement.

I wrote the following JQL, tested it directly in Jira and it is working correctly.
project = Automation AND duedate < now() AND resolution = EMPTY

I replicated it in Make, but I couldn’t get it to work correctly.

This part works:
get(project = "Automation" & duedate < formatDate(now; "YYYY-MM-DD"))

But when I add another validation, the return does not take into account the two statements:
get(project = "Automation" & duedate < formatDate(now; "YYYY-MM-DD") & resolution = empty)

image
image553×638 45.5 KB

I’ve already racked my brains trying to understand the logic of the query, but I still haven’t managed to do it.

I would be very grateful if anyone can help.

Hugs,
Rafa

2

Hello there

not entirely sure, but have you tried using {{emptystring}} instead of empty in your JQL? or EMPTY ? I am not able to check myself with JIRA Module as I do not have any.

3

Hi, @T_Messi
Thanks for your response.

When I use = empty, the query works and returns the data correctly.

And individually, both conditions work:

get(project = "Automation" AND duedate < formatDate(now; "YYYY-MM-DD"))
get(project = "Automation" AND resolution = EMPTY)

The problem is that my query includes both conditions:

get(project = "Automation" AND duedate < formatDate(now; "YYYY-MM-DD") AND resolution = empty)

Either the Make platform doesn’t support this type of query, or the structure/logic of the query is incorrect.

When I run the query directly in Jira, it works perfectly.

4

In that case I am not sure what the issue is then. Have you tried using Make Dev Tool to debug deeper? https://www.make.com/en/help/scenarios/make-devtool
Or maybe someone else who had the issue will jump in at some point.

If you re-arrange the conditions in a different order, I am guessing that does not change anything?
Best of luck