get internal status workflows

Hi, im trying to get the internal status from all workflows in a sharepoint site. I asked this here:

https://sharepoint.stackexchange.com/questions/217585/get-workflow-status-sharepoint-2013/217591#217591

but the answer did not help me. I dont understand why I get always 0 Workflows if I have workflows running. I created a list, added the workflows. They start automatically when I create a new item. The workflow is showed with a column "wflow" ( so the name my workflow ). But when I use the code above or other snippets with a SPWorkflowManager I always get 0 workflows... Any ideas? Thanks in advance.

foreach (SPWorkflow workflow in manager.GetItemWorkflows(item))
{
if (workflow.ParentAssociation.Name == "wflow")
{
foreach (SPField field in workflow.ParentList.Fields)
{
if (field is SPFieldWorkflowStatus)
{
SPFieldWorkflowStatus statusField = (SPFieldWorkflowStatus)field;
if (statusField.Title == "wflow")
{
int statusValue = int.Parse(item[statusField.StaticName].ToString());
// display the status however you want
System.Diagnostics.Debug.WriteLine(statusField.GetFieldValueAsHtml(statusValue).ToString());
}
}
}
}
}

Here is the answer for what I was looking for. Maybe not the best way to do it but now I have a start.

//I was logged as admin but still got an error with the credentials. This solved it.
string siteUrl = "myWebsite";
NetworkCredential credentials = new NetworkCredential("Username", "Password", "Domain");
ClientContext clientContext = new ClientContext(siteUrl);
clientContext.Credentials = credentials;
//Getting the Lists
Web web = clientContext.Web;
ListCollection lists = web.Lists;
clientContext.Load(lists);
clientContext.ExecuteQuery();
//Setting the workflowmanager
var manager = new Microsoft.SharePoint.Client.WorkflowServices.WorkflowServicesManager(clientContext,web);
var subscription = manager.GetWorkflowSubscriptionService();
var instance = manager.GetWorkflowInstanceService();
foreach(List l in lists)
{
var wflowsubscription = subscription.EnumerateSubscriptionsByList(l.Id);
clientContext.Load(wflowsubscription);
clientContext.ExecuteQuery();
foreach(var wfsub in wflowsubscription)
{
//show is a Listbox to visualize it in the Webpart
show.Items.Add(wfsub.Name);
var q = new Microsoft.SharePoint.Client.CamlQuery();
//Only the Title
q.ViewXml = " ";
var listItems = l.GetItems(q);
clientContext.Load(listItems);
clientContext.ExecuteQuery();
foreach(var listItem in listItems)
{
var wflowInstanceCollection = instance.EnumerateInstancesForListItem(l.Id, listItem.Id);
clientContext.Load(wflowInstanceCollection);
clientContext.ExecuteQuery();
foreach(var wflowInstance in wflowInstanceCollection)
{
string wflowStatus = wflowInstance.Status.ToString();
//Adding to the listbox too
show.Items.Add(listItem["Title"].ToString());
show.Items.Add("Workflowstatus " + wflowStatus);
show.Items.Add("Last update " + wflowInstance.LastUpdated);
//Since I didnt find a correct status list I just wrote all types I found... must be corrected.
switch(wflowStatus)
{
case "None": //TODO
break;
case "Locked": //TODO
break;
case "Running": //TODO
break;
case "Expiring": //TODO
break;
case "Expired": //TODO
break;
case "Faulting": //TODO
break;
case "Suspended": //TODO
break;
case "Orphaned": //TODO
break;
case "HasNewEvents": //TODO
break;
case "NotStarted": //TODO
break;
case "Completed": //TODO
break;
case "Started": //TODO
break;
case "Terminated": warningMail();
break;
case "Cancelled": //TODO
break;
case "Failed on Start": //TODO
break;
case "Error Ocurred": //TODO
break;
case "Approved": //TODO
break;
case "Rejected": //TODO
break;
case null: //TODO
break;
}
}
}
}
}
}

I uploaded this answer also in the technet forum: https://social.technet.microsoft.com/Forums/en-US/954492fd-d402-4256-9df3-3cab5ab915b1/get-internal-status-from-workflows-in-c?forum=sharepointdevelopment

Thanks in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Santos9y ago
Here is the answer for what I was looking for. Maybe not the best way to do it but now I have a start.
//I was logged as admin but still got an error with the credentials. This solved it.

string siteUrl = "myWebsite";
            NetworkCredential credentials = new NetworkCredential("Username", "Password", "Domain");
            ClientContext clientContext = new ClientContext(siteUrl);
            clientContext.Credentials = credentials;

//Getting the Lists
Web web = clientContext.Web;
            ListCollection lists = web.Lists;
            clientContext.Load(lists);
            clientContext.ExecuteQuery();

//Setting the workflowmanager
var manager = new Microsoft.SharePoint.Client.WorkflowServices.WorkflowServicesManager(clientContext,web);
            var subscription = manager.GetWorkflowSubscriptionService();
            var instance = manager.GetWorkflowInstanceService();

foreach(List l in lists)
            {
                var wflowsubscription = subscription.EnumerateSubscriptionsByList(l.Id);
                clientContext.Load(wflowsubscription);
                clientContext.ExecuteQuery();
                foreach(var wfsub in wflowsubscription)
                {
//show is a Listbox to visualize it in the Webpart
                    show.Items.Add(wfsub.Name);
                    var q = new Microsoft.SharePoint.Client.CamlQuery();
//Only the Title
                    q.ViewXml = " ";
                    var listItems = l.GetItems(q);
                    clientContext.Load(listItems);
                    clientContext.ExecuteQuery();

foreach(var listItem in listItems)
                    {
                        var wflowInstanceCollection = instance.EnumerateInstancesForListItem(l.Id, listItem.Id);
                        clientContext.Load(wflowInstanceCollection);
                        clientContext.ExecuteQuery();
                        foreach(var wflowInstance in wflowInstanceCollection)
                        {
                            string wflowStatus = wflowInstance.Status.ToString();

                       //Adding to the listbox too
                            show.Items.Add(listItem["Title"].ToString());
                            show.Items.Add("Workflowstatus " + wflowStatus);
                            show.Items.Add("Last update " + wflowInstance.LastUpdated);


                            //Since I didnt find a correct status list I just wrote all types I found... must be corrected.
                            switch(wflowStatus)
                            {
                                case "None": //TODO
                                    break;
                                case "Locked": //TODO
                                    break;
                                case "Running": //TODO
                                    break;
                                case "Expiring": //TODO
                                    break;
                                case "Expired": //TODO
                                    break;
                                case "Faulting": //TODO
                                    break;
                                case "Suspended": //TODO
                                    break;
                                case "Orphaned": //TODO
                                    break;
                                case "HasNewEvents": //TODO
                                    break;
                                case "NotStarted": //TODO
                                    break;
                                case "Completed": //TODO
                                    break;
                                case "Started": //TODO
                                    break;
                                case "Terminated": warningMail();
                                    break;
                                case "Cancelled": //TODO
                                    break;
                                case "Failed on Start": //TODO
                                    break;
                                case "Error Ocurred": //TODO
                                    break;
                                case "Approved": //TODO
                                    break;
                                case "Rejected": //TODO
                                    break;
                                case null: //TODO
                                    break;

                            }


                        }
                    }
                }
            }

        }
I uploaded this answer also in the technet forum: https://social.technet.microsoft.com/Forums/en-US/954492fd-d402-4256-9df3-3cab5ab915b1/get-internal-status-from-workflows-in-c?forum=sharepointdevelopment
Thanks in advance.
0
Rajkiran Swain9y ago
http://www.enjoysharepoint.com/Articles/Details/sharepoint-online-site-workflow-and-initiation-form-parameters-example-using-21914.aspx

https://www.schaeflein.net/setting-workflow-status-in-visual-studio-and-sharepoint-designer/
0
Carlos Santos9y ago
Thanks for the answer. Unfortunatelly the itemCollection is always empty. I do have a workflow working in one list everytime a new item is added. Any idea why I cant go in the foreach-loop?
0
Rajkiran Swain9y ago
1. SPWorkflowCollection itemCollection = mylistItem.Workflows;
2. foreach (SPWorkflow itemWorkflow in itemCollection)
3. {
4. if (itemWorkflow.InternalState == SPWorkflowState.Running)
5. {
6. //...
7. }
8. }
I hope that helps.
0