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 Query by ContentType name issue

I ran into very weird issue in SharePoint Search while querying the items using ContentType name. Query: ContentType={content type NAME} This was giving me the result of content type, however some extra data/results where coming along in the result. There was no clue what is failing there. Spent few hours and got very useful tip from Search Guru,  MIKAEL SVENSON   that not to use ContentType but to replace that with  SPContentType. Modified Query: SPContentType={content type NAME} Learning: We should use SPContentType instead of ContentType. As Contenttype also includes the mime type and not just the name and may cause issues. SPContentType only stores the name. I hope this small piece of information will save your time!
Read more

SharePoint 2013 List CRUD operation using Angular and REST API

Image
This article explains how to perform the CRUD operation on a SharePoint List using Angular JavaScript and the REST API. Create an empty SharePoint 2013 solution, In that add the module of Pages, JS & CSS. In pages module add new item, Test.aspx. In JS module, add new Javascript file with name Controller.js , CommonServices.js &  SharePointListModule.js Other Javascripts needs to add: 1.  angular.min.js 2. anugular.min.js.map Project structure will look something like below: In SharePointListModule.js will create a App of angular, Paste the below code. //App creation var app = angular.module("SharePointAngApp", []) For doing a CRUD operation with SharePoint List, will create an Angular Service to make a SharePoint REST API calls, app.service('testService', ['$http', '$q', function ($http, $q) {//common services}]); This testService having dependency of $http & $q Information related to $http & $q  
Read more

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 will e
Read more