Filter based on Approval Workflow status

From SharePoint Knowledge Base

Jump to: navigation, search

Most of the time when you filter a SharePoint list based on the value of a column, you type in the text string that you want to filter on. However, one of the <sarcasm>really great</sarcasm> features of SharePoint is that when you filter items in a list on an Approval Workflow column, you can't use the text such as "Approved", "Canceled", etc. Instead you have to use the integer value for the status instead of the text value.

Here are the integer values:

  • 0 - Starting
  • 1 - Failed on Start
  • 2 - In Progress
  • 3 - Error Occurred
  • 4 - Canceled
  • 5 - Completed
  • 6 - Failed on Start (retrying)
  • 7 - Error Occurred (retrying
  • 15 - Canceled
  • 16 - Approved
  • 17 - Rejected
Retrieved from "http://sharepointkb.org/Filter_based_on_Approval_Workflow_status"
Personal tools