This is the version of Jira I have “Jira v9.4.15”
I have a jql query that brings me two blocks of tickets. I need to split the two blocks. So, I am trying to introduce a conditional inside the report I have in the action “send email”.
This is the jql:
project = LJS and ((labels in (Release) and ((fixVersion in releaseDate (“before endOfDay(45d)”) and (fixVersion in releaseDate (“after startOfDay()”))) or (fixVersion in startDate(“before endOfDay(45d)”) and (fixVersion in startDate (“after startOfDay()”))) or (fixVersion in startDate (“before now()”))) and status not in (“On Hold”, done)) or labels in (Release) and (fixVersion in overdue()))
(Second block is fixversion in overdue)
This conditional is working fine:
{{#if(now.isAfter(created))}}
It works!! → {{now}} - {{created}}
{{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}} - releaseDate {{fixVersions.releaseDate}}
{{/}}
But next condition doesn’t work, and this is what I need, I need to show tickets in a first block for upcoming releases:
{{#if(now.jiraDate.isBefore(fixVersions.startDate.jiraDate))}}
I want to show upcoming tickets, where the start date is greater than now.
{{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}}
{{/}}
Is it possible to filter tickets with a FixVersion Start date higher than ‘now’?
And in the second block the overdue ones.
Block 1:
{{#lookupIssues}}
Reading 1: {{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}} - releaseDate {{fixVersions.releaseDate}}
{{#if(now.jiraDate.isBefore(fixVersions.startDate.jiraDate))}}
YES ==> I want to show upcoming tickets, where the start date is greater than now.
{{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}}
{{/}}
{{/}}
Bblock 2:
{{#lookupIssues}}
Reading 2: {{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}} - releaseDate {{fixVersions.releaseDate}}
{{#if(now.jiraDate.isAfter(fixVersions.releaseDate.jiraDate))}}
YES ==> I want to show overdue tickets:
{{key}} - {{summary}} - now {{now}} - startDate {{fixVersions.startDate}} - releaseDate {{fixVersions.releaseDate}}
{{/}}
{{/}}
I never get a “YES ==>” line, none of the blocks. The conditions does not work.