Create a Breakdown for Catalog Tasks by State

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2023 03:09 PM
I'm trying to create a breakdown on the 'State' of Catalog Task [sc_task] records that I've already built indicators for. However, when I create the new source record, the 'State' field is not available/selectable on the [sc_task] facts table.
The field is configured on the form and in the table definition, so I'm unclear why it's not available here.
I've tried looking from some method to dot-walk to the RITM or REQ from here and hit one of those records State, but that's not an option either.
So I'm a bit lost on where to go next.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2023 11:33 AM
Check out the Incident.State Breakdown Source as a sample
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2023 11:23 PM
But Incident.State uses 'sys_choice' table for ensuring this.
Here, the state is an Integer field. I can't see how that will help.