I have a report running on the Task table trying to show a holistic view of tickets (i.e., INC, CHG, PRJTASK, etc.) that are non-closed and assigned to a particular group. This report is broken down by assignee. What we find is that some INC tickets that are in an On Hold state are missing. That's because when pulled from the task table they are showing as Closed Complete instead of On Hold, and we have all Closed Tickets filtered out. These tickets do show up on a report ran against the INC table.
Does anyone have any suggestions of how to get those to appear? I presume it's because they share the same value on both tables. I don't want to change them though because other states shar the same value without any problems...so I imagine there is something causing this to show up a certain way in relation to On Hold.
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 choice on our Task table:
David A
Hello,
To fix that issue I use the field "Incident State" from Task table. That field is specific to incident so for the reporting activities the result will be compliant.
