SharePoint 2007/10 - How to Filter List Items by Workflow (Approval) Status

-
In order to filter documents or items in a list by status of the workflow, we can create a new view and set the filter using the column [Workflow Status].
But if we try to insert as a filter "Approved" or "Rejected", we do not get results.

The Workflow Status is stored as a numerical value!
The values ​​are as follows:

Not Started - 0
Failed on Start - 1
In Progress - 2
Error Occurred - 3
Canceled - 4 (manually)
Completed - 5
Failed on Start (retrying) - 6
Error Occurred (retrying) - 7
Canceled - 15 (from workflow)
Approved - 16
Rejected - 17

The correct setting of the filter will then be like the following image:


Pay attention to the values ​​for Canceled!
If the cancellation is done automatically by the Workflow, use the value 15, but if the Workflow is stopped manually by the administrator (eg because of error), then you need to use a value of 4!

Comments

Post a Comment

Popular posts from this blog

Sharepoint 2010 - Enable/Disable Ribbon Button with EcmaScript

-
I show you a detailed example of how to enable and disable a ribbon button according to the current user’s group. The example uses “EnabledScript” attribute of the CommandUIHandler of the ribbon button. Then the EnabledScript is built with EcmaScript to find groups and user info. Lets Start with creating a Ribbon button first. 1. Create a empty project. 2. Deploy it as a Farm solution. 3. Right click on the feature and click “Add feature”. 4. Right click on the project and add a new “Empty Element” item. 5. Next add the below code to add a custom Ribbon button to your document library. <Elements xmlns=”http://schemas.microsoft.com/sharepoint/” > <CustomAction Id=”ButtonForGroupUsersOnly” Location=”CommandUI.Ribbon” RegistrationId=”101″ RegistrationType=”List” Title=”Owners Group Button”> <CommandUIExtension> <CommandUIDefinitions> <CommandUIDefinition Location=”Ribbon.Library.ViewFormat.Controls._children”> <Button Id=”Ribbon.L...
Read more

Sharepoint 2010 - Customizing Quick Launch with pages

-
Image
How to show different quick launch menu items in different pages? The quick launch in Sharepoint is an object common to all pages of the site. To show menu items according to the page you visited, I followed client side method with javascript (jquery). Here's how, using Sharepoint Designer 2010. On css stylesheet of the site, I added this instruction, which hides all the items in the Quick Launch: . s4-ql ul.root> li { display: none; } Then, make note of the position of the menu items in the quick lanuch: eg. 0 - Document Libraries 1 - Lists 2 - MyLink      0 - MySubLink1      1 - MySubLink2 3 - MyOtherLink 4 - MyLastLink The pages follows the following rules: Page1 shows 0,1,4 Page2 shows 0,2,3 Page3 shows 0,2 (and sub ​​links 1), 3.4 And now, I change the master.page, adding references to jquery and inserting the following code: //get all items in the quick launch var li_nav = $(".vertical-menu>ul>li"); //get...
Read more

SharePoint - Add button Apply to List Item Edit Form for Saving Item without closing form

-
This post describes how to create an Apply button in list item edit form, to save data and reload form, without redirect to list (or Source). Create a custom edit form with SharePoint Designer. Open form in edit mode. Create new parameter of type QueryString for Source, named Source: when page refresh after saving data, url maintains Source (i.e. for redirect to list when you click on Save or Cancel). Then, search for this code <xsl:param name="dvt_apos">&apos;</xsl:param> <xsl:variable name="dvt_1_automode">0</xsl:variable> And add code below: <xsl:param name="ListItemId">0</xsl:param> <xsl:param name="Source"></xsl:param> Search for button save/cancel in xslt, find this code: <SharePoint:SaveButton runat="server" ControlMode="Edit" id="savebutton2"/> Add code below (the button): <input type="button" value="Applica...
Read more