
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2018 12:32 PM
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?
Solved! Go to Solution.
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 06:22 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2018 01:18 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2018 01:30 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2018 01:49 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2018 06:22 AM
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.