Create a custom view on Workflow Task Status

I came across to the requirement to create a custom view based on workflow status.

Requirement was to show all the approved items.


I found a interesting stuff, Filter will not work if we use words like below image:


we would need use the number rather than the words (e.g. 2 instead of In Progress, 4 instead of Cancelled etc)

Following list might help for this kind of requirement:

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
Approved
16
Rejected

17

Hope this will save your time!


Comments

Post a Comment

Popular posts from this blog

Search Result Webpart,Filter result If QueryString is present in URL

Image
There was a requirement to filter the search result based on QueryString present in url, and if no QueryString present then should populate all the results. Issue was simple to resolve if every time there is QueryString present, then below Query will do the job. Below filtering the result by checking managed metadata property equals the query string value. Above query was filtering the result based on QueryString given in URL. However it fails if there is no QueryString present in url.  "No result found" message appear. Ideally should populate all the results. And filter should be optional in query for this scenario. So I need to modify the query and to add some condition like, if QueryString present then check managed metadata property equals the query string value, else no. To achieve this, there is syntax  {searchboxquery} {? <some KQL expression> } , If MyParameter querystring is not present in URL,  then just first part of KQL query wi...
Read more

SharePoint 2013 Workflow gets canceled automatically

Hi, I was struck with the error of Workflow gets canceled automatically. Scenario was : A new SP 2013 installation, one server with SP, WF, etc and the other is simply SQL Server. Went through the installation steps for Workflow including the powershell bits. In designer, I am able to create a simple workflow and select 2013 as the type. When the workflow is run, is shows internal status is canceled and has the following error text below. RequestorId: 55c6990b-c4a6-352c-4a5b-449fc1aecac4. Details: System.ApplicationException: HTTP 401 {"x-ms-diagnostics":["3001000;reason=\"There has been an error authenticating the request.\";category=\"invalid_client\""],"SPRequestGuid":["55c6990b-c4a6-352c-4a5b-449fc1aecac4"],"request-id":["55c6990b-c4a6-352c-4a5b-449fc1aecac4"],"X-FRAME-OPTIONS":["SAMEORIGIN"],"SPRequestDuration":["61"],"SPIisLatency":["1...
Read more

Permission denied for "Add and Customize Pages" in Sharepoint Online

Image
Problem: I have created root site in SharePoint Online, weird problem I started facing is being a site administrator I was not able to customize the page/ upload the any page or master page. As in image below, for some reason I am set as Deny to "Add and Customize Pages". The problem is related to 'Scripting Capabilities' being turned off by default for the root site collection in Office 365. I found some article on community: https://support.office.com/en-us/article/Turn-scripting-capabilities-on-or-off-1f2c515f-5d7e-448a-9fd7-835da935584f?ui=en-US&=amp&rs=en-US&ad=US It mentions that turning on scripting through the Sharepoint Admin Settings and wait around 24 hours. However, this did not work for me. still the issue was there. Following lines of script did a trick. Solution: Connect-SPOService -Url https://<yoursitename>-admin.sharepoint.com -credential <admincredentials> Set-SPOsite https://<your root site ur...
Read more