Using variable in the endOfWeek() function

[Tom Scoggin]

I created two Variables and was trying to pass them to the endOfWeek() function like this. 

{{#issues}}
{{#if (and(created.isAfter(endOfWeek(WeekVarOne)), created.isBefore(endOfWeek(WeekVarTwo))))}}

If I replace the variable with a number like -1 or -8 the statement works just fine. I can also print the variables to my email. I just can't get them to work in this situation. I also tried to use WeekVarOne.asNumber and that didn't work.

Any thoughts? Also, can you iterate the variable inside of a While loop?

Thanks in advance.

[Jack Brickey]

I don't believe using an automation variable inside JQL parameters is supported. Have you seen info supporting this?.

[Bill Sheboy]

Hi @Tom Scoggin 

Short answer: no, that is not possible.

Once inside of an iterator, an automation rule cannot "see" anything except at that scope, and lower.  It cannot see other issues, variables, or even data at a higher scope within the same issue which is the source of the iterator.

My understanding from other posts is the Atlassian team has tried to address this a few times, without success.

The only work-around I know is to use the match() function with a regular expression when using the inline version of iteration.  However that would not work for your scenario as you want to filter on one thing (i.e., created) and then access other fields.

Based upon your other question (for table data), you could also use multiple calls to Lookup Issues, with different JQL for each, and save the pre-formatted table data in created variables.  Then use those variables in an email, message, etc.

Kind regards,
Bill