Need help with Issue created date query

Question

Hi,

I want to filter all the jira tickets which belong to X project and were created Y minutes ago and Can someone please help me with the following query?

This is what my query looks like: 
project = X AND createdDate > '-20m'

Questions:
1. can someone please explain what is the difference between createdDate and created? 
2. For filtering issues with days I am using 
project = X AND createdDate > '-20d'

Can someone please confirm if this is correct? Basically I am running an automation basis this filter and it doesn't seem to work.

John Funk · Answer

The main test is to run it and see if it is provided you with what you expect.  :-)

This should do the trick for you:

project = X AND (created > -30d OR updated > -30d)

Piyush Dinde · Answer

Thanks @John Funk

I shall try the suggested approach. I think it should work.

Also, I want to select issues which were created or updated in the project

project = X AND created > -30d OR updated = -30d

With this approach I am getting all the tickets from all the projects. Could you help me with the right query?

John Funk · Answer

Hi @Piyush Dinde  - I have never seen a difference when using either created or createdDate. Both should work as you intend.

Your last query should also work - when you run it as a filter, do you get the results you expect? (Outside of the Automation that you are using).

On the time, unfortunately, there is not way to currently do that. You could use createdDate > startOfDay() to see issues created today. But you can't control based on time of day. You could put in a value for minutes inside the ( )  for the time you are running it, but you would have to do that manually and not use with automation.