How to provide a list of all Active and Complete workflows and filter by a DataField?

Hi,

Searching across all worklist items should be done using the SourceCode.Workflow.Managment API. This will get you all the Open, Available or sleeping worklist items regardless of owner. Look at the following section in the documentation to see how this is done: Developer Reference > Processes > Accessing > How to access and return information from the Global Worklist. This is the preferred way to access these items if you need to do something with these instances. It is not commonly used for reporting.

The completed instances are only available through the reports. Reports pull from the K2 Reporting SmartObjects and you can query the Event_Instance SmartObject to see a list of ALL Events. This report will however show all events, whether they are Server Events or Client Events. It is up to you to discover what type the event is. This report will also report on all instances whether still active or completed.

The SmartObject is most probably the way you should go. You can filter on any of the columns, but as I mentioned it will be up to you to determine which events are actually client events. Even this is not too difficult. Create a table where you specify which Events are client events and use this in the SmartObject execution using ADO.NET in the "WHERE EventName in" clause:

SELECT * FROM Event_Instance
WHERE EventName IN ('Approval', '2nd Approval Task')

Hope this helps!