Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I want a query to show me all new stories added to a release in the past 24 hours please.

siva boddu December 12, 2020

Need a query  all new stories added to a release in the past 24 hours

1 answer

1 accepted

0 votes
Answer accepted
Jack Brickey
Community Champion
December 12, 2020

Something like this maybe

fixVersion changed to 3.37 after startOfDay(-1d)

Replace 3.37 with your version and adjust the time factor to suit. 

siva boddu December 12, 2020

Hi Jack thanks for the reply

This query shows only changed fixversion but i want both  all newly created fixversion and changed fixversion in past 24 hrs.

Thanks.

Jack Brickey
Community Champion
December 13, 2020

Ok. Your initial post seemed to imply a specific release. So you could check if the fix version was empty and no longer is...

fixVersion was empty BEFORE startOfDay(-1d) and fixversion is not EMPTY Or (fixVersion changed

or if you simply want to see where the FV changed...

fixVersion changed after startOfDay(-1d)

siva boddu December 13, 2020

Thanks for the response Jack

will apply 

Thanks

Suggest an answer

Log in or Sign up to answer