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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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