Wednesday, October 8, 2008

How to create a view based on workflow status column

Hi All,

I came across to one requirement where i needed to show only Completed Workflow Items. That means i have one workflow attached to a list and when workflow is completed then only i have to show that item.

so i though of creating a view for that. View will show only those items for which Workflow is completed, not In Progress Or any other. so i though of filter on that workflow field.

I tried to create view. So i went for create view, i gave name of view and defined filter condition saying that Field is equal to "Complete". and press OK. but when i came to the view, i did not find any items.

I googled a bit, and then come to know that actually these fields are stored as numeric values. Here are the numeric values for different workflow statuses.

In Progress - 2
Complete - 5
Canceled - 15
Approved - 16
Rejected - 17

So now you must have got the idea, i went back and changed it to workflow field equal to 5 and it worked!!!!

That's it. your job is done.

14 comments:

Guanyu said...

wow, thanks a million.. those values are exactly what I need..

Guanyu said...

wow, thanks a millions, that's exactly what I need...

kjhoward said...

Thank you, this is just what the doctor ordered.

Anonymous said...

I've got some showing 5 for the workflowstatus, while they seem to be exactly as the 16 approved ones on the surface. Any idea?

Thanks.

SharePoint Kings said...

@Anonymous,

not getting your scenario please describe.

Anonymous said...

Thanks man, you saved my day.

Anonymous said...

Thanks man, This is what i was needed

Anonymous said...

Thank you, i would never think of this

Anonymous said...

thanks, helped me a lot. For those who want to filter for workflows where Error Occured, use the value 3

SharePoint Kings said...

Anonymous, thanks for
Error Occurred - 3

gouri said...

great post!!
thanks a lot... worked like a charm.

gouri said...

thanks a lot!! very very helpful!

Anonymous said...

Lifesaver my son , you just made my world a slightly better place to live in

Anonymous said...

This is great. Thanks.
I am trying to make this work for in a custom made workflow in SP Designer... but it don´t seems to work.

Not very logical solution. :) :)




Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to sharepointkings@gmail.com with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to sharepointkings@gmail.com