How to set a filter to know bugs transfer into and bugs transfter out

[Haojie Yang]

Hello,

I have a fiter according to assignee. The filter is as below:

project in (HX11-EU-DHU-H, DHU606S) AND issuetype = Bug AND status != Closed AND assignee in (membersOf(HX11-Visteon), haojie.yang)

I want to know the bugs transfer into this filter and bugs transfter out during last 24 hours. how should I set the filter?

[Walter Buggenhout]

Hi @Haojie Yang and welcome to the Community!

That is an interesting question. I assume you would like to answer 2 questions basically:

• which bugs are now on your list and were not 24 hours ago;
• which bugs were on your list 24 hours ago but not anymore

How you find that information depends very much on how your process works. To not overcomplicate things, let's assume that your projects and issue type (bug) don't change. That means that issues can appear on / disappear from your list through changes of either status or assignee.

For clarity of information, I would split up your question in a few separate sections:

bugs from your list that were closed yesterday

project in (HX11-EU-DHU-H, DHU606S) AND issuetype = Bug AND status = Closed
AND assignee in (membersOf(HX11-Visteon), haojie.yang)
AND status CHANGED TO Closed AFTER -1d

bugs that were added to the list as the assignee changed in the last 24 hours

project in (HX11-EU-DHU-H, DHU606S) AND issuetype = Bug AND status = Closed
AND assignee in (membersOf(HX11-Visteon), haojie.yang)
AND assignee WAS NOT IN ((membersOf(HX11-Visteon), haojie.yang)) DURING (-1d, now())

You can obviously try to combine these filters, but it would become unclear which issues were added or removed and why. So creating separate filters for these changes would probably make more sense.

Based on these examples, you can obviously cover different scenarios as well, e.g. for issues that dropped off your list because the assignee changed in the opposite direction. And so on ...

Hope this helps!

[Piyush A (STR)]

That’s an interesting answer. According to me, better to use startofday() than -1d ?

[Haojie Yang]

what does startofday() mean?

[Haojie Yang]

it seems when I use "was", I can't use "membersOf". It seems like a bug.