in einer Automation zwei Listen in einer E-Mail, einer {{#lookupIssues}}

[Kristina Galwas]

Ist es möglich mit der {{ #if( Bedingung in einer Automation nach dem Fälligkeitsdatum zu filtern? 

Folgendes habe ich ausprobiert, leider werden damit die Listen leer. 

[Marc - Devoteam]

Hi @Kristina Galwas 

Can you provide a screenshot of the configuration of the branch action.

Is see you have set the variable as new {{distinctAssignee}}

I wold also urge to have a log action before the lookup to see what the values are for the variable {{distinctAssignee}}

[Kristina Galwas]

Hi @Marc - Devoteam

I will gladly send you a screenshot

[Marc - Devoteam]

HI @Kristina Galwas 

If you place a log action before the lookup in the branch to see what the values are for the variable {{distinctAssignee}}.

Is there any result, when running the rule?

[Marc - Devoteam]

Hi @Kristina Galwas 

You can also check the earlier post on the community.,

https://community.atlassian.com/t5/Jira-questions/How-can-I-use-Advanced-Branching-in-Automation-for-unique/qaq-p/1909075 

[Kristina Galwas]

Hi @Marc - Devoteam 

I only get a result in a list if I remove the if ({{#if(durdate <= “0”)}} function.

the result when I remove the IF function looks like this:

with IF function I get the following result: (the list remains empty)

[Marc - Devoteam]

Hi @Kristina Galwas 

What kind of field type is "durdate"?

Is this a date field, number field or else?

[Kristina Galwas]

Hi @Marc - Devoteam 

It is the due date - i.e. a date field.

I just saw that I have a typo in it, but even if I write duedate, I have the same behavior.

[Marc - Devoteam]

Hi @Kristina Galwas 

As it's a dat field you can't compare it with a number. You can only compare to a date.

So {{#if(durdate <= “0”)}} won't work, the "0" needs to be replaced with a date.

[Kristina Galwas]

Hi @Marc - Devoteam

How can I build the function so that only the tickets that are already overdue are issued? In other words, if the due date is in the past?

maybe like this
{{#if(duedate <= today)}}

or

{{#if(duedate <= now())}}

[Marc - Devoteam]

HI @Kristina Galwas 

This should work:{{#if(duedate <= now())}}

today() is not a function in Jira

[Kristina Galwas]

Hello, thank you for your answer and your solution approach.

Unfortunately, this does not solve my problem.

I would like to display the following in an e-mail:

The due date has passed for the following tickets:

- IT-55: Test 1 due since 01.01.2024

- IT-18: Test 1 due since 09.05.2024

- IT-47: Test 1 due since 24.09.2024

The following tickets are still open:

- IT-105: Test 1 due since 15.10.2024

- IT-794: Test 1 due since 01.11.2024

[Mohanraj Thangamuthu]

Hello, Good day. You could try the following condition.

[Kristina Galwas]

Hello, thank you for your answer and your solution approach.

Unfortunately, this does not solve my problem.

I would like to display the following in an e-mail:

The due date has passed for the following tickets:

- IT-55: Test 1 due since 01.01.2024

- IT-18: Test 1 due since 09.05.2024

- IT-47: Test 1 due since 24.09.2024

The following tickets are still open:

- IT-105: Test 1 due since 15.10.2024

- IT-794: Test 1 due since 01.11.2024