Filter Help

[Market America's JIRA Admin]

I am having a hard time getting the filter I need.

I am trying to find how many tickets a certain user has transitioned during a certain period of time. I need 2 filters one from 12am-11:59am and the other from 12pm-11:59pm and I need them to roll daily, meaning I don't want to have to edit the filter everyday. I have...

Status changed from XXX by USERNAME

... but I am not sure how to handle the timeframe breakdown.

Any suggestions?

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Use relative dates.Examples below:

status changed by USERNAME AFTER startOfDay()

status changed by USERNAME AFTER startOfDay(-1) before startOfDay()

status changed by USERNAME AFTER -5d

[Market America's JIRA Admin]

Thanks! I think

status changed by USERNAME AFTER startOfDay()

status changed by USERNAME AFTER startOfDay(-1) before startOfDay()

will at least get me close enough to my goal!

[Bhushan Nagaraj]

Hi

You can do something like this but is is not possible to specify only the time. You have to specidy the date as well

status changed by USERNAME before "2013/05/14 11:59" AFTER "2013/05/14 00:00"

status changed by USERNAME before "2013/05/14 23:59" AFTER "2013/05/14 12:00"

[Market America's JIRA Admin]

That won't work becasue I would have to edit it daily, which isn't really workable for what I need the info for.

Maybe there is someway I could do it and just have one for today and one for yesterday?