How to filter status of projects

[Thomas N.]

I try to filter my status in the following way:

(status in (Offen, Anwendungstest, Umsetzung, Dokumentation) AND (assignee = currentUser()))

I miss the status "Umsetzung" and "Dokumentation" in the results. "Offen" and "Anwendungstest" is displayed.

Maybe "Umsetzung" and "Dokumentation" is saved in the database with a different wording?

Any ideas how to fix it?

[Thomas N. · Accepted solution]

Hi,

I solved it due to some adjustments with the wording. Some of the status have to written with "" within the filter, e.g.:

(status in (Offen, Anwendungstest, "in Umsetzung", Kundendokumentation) AND (assignee = currentUser()))

Thank you for kindly help!

[Alexander Hohmann]

That is good to know - that a status containing a space character needs to be put between quotation marks. Thank you for the resolution!

[Alexander Hohmann]

Have you looked into the actual workflows? Sometimes, when you use standard status, they are displayed in a localised way in work items but use the original English in the workflow. E.g. I use "Delivery" in one workflow (and related automation) but "Auslieferung" is displayed in the work items.

[Thomas N.]

Hi Alexander,

in the current workflows it is displayed in the same way in German. But maybe it is saved in a different way in the database (English) but I am not firm how to see it.

[Alexander Hohmann]

Did you actually have a look at the workflow graph? E.g. by chosing the option "Workflow anzeigen" in the dropdown list for status change in some work item of your choice, or in your project settings?

I might just be shooting into the dark here, but have you tried removing the blank spaces in the IN() clause? Just guessing.