The CreatorCon Call for Content is officially open! Get started here.

State on task table does not include states for incidents.

Brian Lancaster
Tera Sage

I'm trying to do a report on all incident / request items that are currently opened.  I'm trying to use the task table so it is in one report.  I noticed that when I try to say state is one of none of the state that are available on the incident form are showing to be selected.  Is this a known issue? 

1 ACCEPTED SOLUTION

Looks like state field for the different extended tables have the same values it is not showing up.  So I had to add Add Or condition and do a section for the incident task type and just use the incident state.

View solution in original post

4 REPLIES 4

Mike Patel
Tera Sage
you can use active field since incident has its own field called incident_state

Incident has state as well which is synchronized with incident_state.  The state field comes from the task table.  Also using active will not work as it will show resolved incidents.

Prateek kumar
Mega Sage

May be this can help

https://community.servicenow.com/community?id=community_question&sys_id=e4c2c593dba59f444fc2f4621f9619da


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

Looks like state field for the different extended tables have the same values it is not showing up.  So I had to add Add Or condition and do a section for the incident task type and just use the incident state.