Filter on State = 'Closed Complete' shows other states with same value

[AryanJha]

Hi Community,

I was working on something and encountered an issue on the User Task table. When applying a filter like:

Active = true  
AND  
State = Closed Complete

The expectation is that only records with "Closed Complete" as the state should appear. However, I'm seeing records with Closed, Resolved, and On Hold states as well.

I checked the sys_choice table, and I noticed that all of these states (Closed, Resolved, On Hold, and Closed Complete) have the same backend value (value = 3).

This explains why the filter is including all these states — because from a backend perspective, they share the same value.

Interestingly, I checked the same on my PDI (Personal Developer Instance) and the behavior is exactly the same there too.

My question is:

• Is this a glitch or limitation in ServiceNow's platform?

• Is there a recommended way to filter specifically by the label "Closed Complete" and not include other states with the same backend value?

Looking forward to your insights.

Thanks!