Last post May 04, 2009 04:55 AM by kach
May 04, 2009 04:55 AM|kach|LINK
When I tested, I found that the TrackingDataItems collection property of SqlQueryTrackingOptions, is used like a group of OR filters.
SqlTrackingQueryOptions options = new SqlTrackingQueryOptions();
options.WorkflowType = _workFlowType; // some workflow type
// Adding filters
options.TrackingDataItems.Add(new TrackingDataItemValue("InitialState", "RequestType", "Movement" );
options.TrackingDataItems.Add(new TrackingDataItemValue("InitialState", "Submitter","Chaitanya");
So, this gives me the resultant instances which have either
RequestType = Movement OR Submitter = Chaitanya [of InitialState acitivity]
But what if I want to add in a filter condition where I need the instances which have both
RequestType = Movement AND Submitter = Chaitanya [of InitialState acitivity]
Is there any way to perform this check to constrain the results?
Please let me know.