Task list – State filter shows duplicate values for same label (New, Work in Progress, etc.)

[savaliya]

Hi Community,

I’m working with the Task [task] list and trying to filter records assigned to me based on the State field.

When I add a filter like:

Assigned to = (me) State is one of New, Work in Progress

the State choice list shows many duplicate values, for example:New, New, Work in Progress, Work in Progress

Even though the labels are the same, they appear multiple times, making it difficult to build a clean filter (see below image).  And the values are too much (i just want to have state values from Incident, Incident task, RITM and Catalog Task).

What is the recommended way to to give posibility to Filter  via state across multiple task types and Avoid duplicate State values?
Thanks in advance!

[vaishali231]

Hi @savaliya 

This is expected behavior on the Task table.

The State field is defined separately for each child table (Incident, Incident Task, RITM, Catalog Task). Even if the labels look the same (New, Work in Progress), they come from different tables, so the filter shows duplicates.

Best practice :

Use Active = true instead of State whenever possible.

If you must use State, filter by Task type first, then apply the State condition.

For a clean view, use separate lists per task type (Incident, RITM, Catalog Task).

Avoid changing sys_choice records or trying to remove duplicates on Task.

*************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.

Regards
Vaishali Singh

[vaishali231]

@savaliya 

Hope you are doing well.

Did my previous reply answer your question?

If it was helpful, please mark it as correct ✓ and close the thread 🔒. This will help other readers find the solution more easily.

Regards,
Vaishali