What would cause a field choice not to show up as an option on a Report filter condition?

[jhill1]

Hello All,

What would cause a field choice not to show up as an option on a Report filter condition as an option?

Incident extends task, which is where this field resides.

Other choices from the field on the task table are there, just not this one. What are the possibilities?

And I have checked the sorting... it is nowhere in the list.

Thanks in advance.

J Hill

[jhill1]

Interestingly... the Report works fine if I select "contains Workspace 9" but I can't use "is Workspace 9" because the choice is not in the dropdown.

It's so strange that I can see and run reports on the choice, even group by the choice, but it's simply missing from the dropdown.

Best,

J

[Chuck Tomasi]

Do all choices have unique values?

[jhill1]

Hello Chuck,

They are all unique for this particular missing choice, but others are not.

Also, is there some sort of upper limit to how many options can appear in a drop-down for filtering? There are over 2000 in this case.

Though they do not all appear at once when creating an incident due to dependencies, they do when running report (except for this one missing one of course).

Thank you,

J

[Chuck Tomasi]

I've temporarily run out of ideas on this one. You may need to reach out to support. I'll be curious to hear what they find.