One of the known issues with SharePoint 2007 is the inability/quirkiness of filtering a view based on the status of a workflow field. While this is a pain, there is an easy workaround. Simply create the filter and tell it to look for the integer representation of the status value you are looking for, like this:
This will create a filter that returns all “Approved” items. The codes are:
Status | Value | ||
Not Started | 0 | ||
Failed on Start | 1 | ||
In Progress | 2 | ||
Error Occurred | 3 | ||
Canceled | 4 | ||
Completed | 5 | ||
Failed on Start (retrying) | 6 | ||
Error Occurred (retrying) | 7 | ||
Canceled | 15 | * This is defined but I don’t think this value is used | |
Approved | 16 | ||
Rejected | 17 |
12/19/2007 Update: Filled in list of values using the actual values found in the field definition itself.
5/28/2008 Update: Hit by a flash of the blindingly obvious. If you put the status fields on a view, then view that in the Datasheet mode, it shows you the integer values. I don’t know why I hadn’t seen this before ….
Thanks, great info! I had been wondering why text values wouldn’t work for quite awhile. The numeric values work great.