{{lookupissues.size}} for IF ELSE Automation not giving expected results

[Daniel Landino]

Hi Everyone!

Have been stumped with this one for several hours, any help is really appreciated.

I'm using {{lookupissues}} and {{lookupissues.size}} on a custom field to try and publish different messages (if/else) to slack based on if the jql returns 0 or anything greater than 0 but it's not working.

I've simplified the example as best I could but Attaching a screenshot that I think best outlines the problem I am facing.

Both tests are returning the Else even though you can see the 6:01pm run has an associated item.

[Daniel Landino · Accepted solution]

I think I found something that seems to get it working via https://community.atlassian.com/t5/Jira-Core-Server-questions/Using-the-lookupIssues-to-find-number-of-issues-in-an-Epic/qaq-p/1681084

{{lookupIssues.size|0}}

[Fabian Lim]

Hi @Daniel Landino

Welcome to the community!

It's not clear what what you are trying to do with = 0d, but I'm assuming you want to capture tickets are due the same day.

You may want to use something like startofday() jql instead: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/ 

[Daniel Landino]

Hey Thanks for the reply. Yes that's the aim of the 0d and I'll check the startofday function out for efficiency but it's not the issue here - that filter is already being used successfully for several other purposes.

The count of the lookupissues.size is the problem - it's not working properly in the advanced compare if stuff