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 ….
davidwise