Some states don't appear when querying the task table

markdesouza · ‎04-23-2018

I have a user that is trying to get a view into all of her tasks (incident, change, it request, etc). She's trying to view the task list where the assignment is herself. She is trying to filter out states from incidents by using 'is not one of" awaiting problem, awaiting user info, awaiting evidence or awaiting vendor but in the state field she doesn't see the first three items. We also see awaiting vendor twice. Why would those items not be there, or in the case of the awaiting vendor, why would there be two entries? How can we add them?

Scott Jordheim · ‎04-23-2018

Something to be aware of as well: If the numbers tied to the various record States are the same when that properly is set to true, weird behaviors will arise when reporting from Task.

IE - If Closed Complete on Request has the same State number as On Hold for Incident, they will fight each other. They may have to design filters around that.

View solution in original post

Jan Spurlin · ‎04-23-2018

The values of "awaiting problem" etc - are not in the state field on incident. For incident, those values are in the field On Hold Reason. The state field is on the task table - and you are looking at the values for multiple extended tables. I do not see "awaiting vendor" in the Kingston baseline. Maybe these values were added? check the Dictionary entry for the task table for the state field/column.

davida1 · ‎08-04-2022

We have a similar issue; we report on the Task table with these criteria:

Active = True
State IS NOT "Solution Proposed"
Assigned to IS (Dynamic) ME

When the State changes to "On Hold", it disappears from the report. As far as I can tell, all three criteria are true, so any ideas why it's not appearing?

Note: FWIW, we DO have "On Hold" as a State choice on our Task table, and it doesn't conflict with any other State value.

David A