if issue matches JQL doesnt work with start of day(-7d)

[rahul sharma]

Im looking for a way to check with automation if the target start matches 7 days from the current date.  If so i would like to flag the Userstory.

It al works when i use the start of day without the -7 days. like below

"Target start" <= startOfDay()

But when used with the -7d it doesn't work. I have used multiple options like -7 or -1M

So "Target start" <= startOfDay(-7d) doesn't work for example. 

Just to verify i really need the target start attribute to check.

Anyone that can help me with this?

[rahul sharma · Accepted solution]

I'm so sorry I found my problem:

This was turned on. When I turned it off it works all great. 

Thank you for all the help 

[Valerie Knapp]

Hi @rahul sharma , welcome to the Atlassian Community and thanks for your post.

If you are looking for dates in the future, you shouldn't use a negative number.

If you want 7 days from now, you would need to write something like this

"planned start[time stamp]" >= 7d

I would anyway verify this first in the Filter section / Search work items section to make sure you are retrieving the correct work items you would like to flag.

I just recorded a short Loom to show you how I got this JQL https://www.loom.com/share/f2c2c0309b4543f9b06afa0164f9f709?sid=8cc5d7c6-320b-4dc5-87f2-9e0f511e0993 

Please have a look and see if this helps you.

Best wishes

[rahul sharma]

sorry! i have been writing the text all wrong what i meant was 7 days from now(). I meant the timestamp of today. so i would like to go back in history. I did try the JQL in the issues tab but when i use it in the automation it doesn't.

[rahul sharma]

when i put my testcase to the target date of today it works with the following

"Target start" = startOfDay() 

[Marc - Devoteam]

Hi @rahul sharma 

Welcome to the community.

Set the number of days as followed: in the JQL  startOfDay("-7d") for past dates or startOfDay("7d") for future dates.

[rahul sharma]

i have tried this JQL but no luck. when I test it in the automation it returns the userstorys that i want to alter but when i run the automation it doesn't. 

Just for reference i did try it with just startOfDay() the flag works

[Marc - Devoteam]

Hi @rahul sharma 

Can you provide the following:

1. what type of project is this (e.g., company-managed, team-managed, etc.), 

2. images that show your complete rule.

3. images showing the details of any relevant actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. Explain where the issue is.

[rahul sharma]

Alrighy hope this helps

1. team management

2. my complete rule is as following

3. 

This is the part that when i try this it doesnt work

4.

5. The issue is at number 3. That jql does work in the issues tab when i try and filter my US but when I use it shown as in the picture it does not work. 

Hope this helps. If there is more information needed just let me know please. I really need this to work. Thanks in advance.

[Marc - Devoteam]

Hi @rahul sharma 

Set the JQL in the scheduled action to:

Project = NIS and resolution = unresolved and "Target start" = startOfDay("-7d")

The condition is not needed, as only items matching the JQL are already found. 

[rahul sharma]

I have changed the JQL scheduled action but it still says no actions performed in the audit log.

[Marc - Devoteam]

Hi @rahul sharma 

Remove the condition after the scheduled trigger, this will cause failures and is not needed.

This as based on the JQL in the scheduled trigger, it will only find issues based as result of the JQL in the trigger.