How can I find all inactive/invalid choice list values (values that show as blue) for a single field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2015 08:57 AM
We have a custom field on the incident table that was originally a string field with no choice list, but now a choice list exists. Is there a way to query this field to return all of the items with invalid values for this field? I would like to create a module under the Incident application menu for itil users to clean up their old incidents with these invalid values.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2015 09:02 AM
I'd create a list where the field in question "Is not one of", then select all the valid values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2015 09:05 AM
I tried this, but the choice list has grown to 700+ choices. When I try to open an incident form from this list, the page remains blank and never opens the form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2015 09:12 AM
What table are you reporting off of? You should be querying the task table on which the choice field exists.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2015 09:22 AM
I'm not running a report. I've been trying to use the filters while editing the module, so only the fields from the incident table are available. The problem arises when trying to open the incident form with this many filters. Since there are 700+ choices that is it filtering out, the incident form is unable to open. I was wondering if there was another was to search for all of these items with invalid values. Maybe some type of javascript query?
