Symptoms
Unable to run ADO Select Query in SmartObject
Diagnoses
Exec query being used instead of Select Query:-
EXEC WorkflowReportingService_WorkflowInstanceReport.ProcessInstanceDetail @ProcessSetFullName = [[ProcessNameList]]'.
Resolution
Use Select ADO Query instead of Execute query. Refer to "SELECT Support" section here:-
https://help.k2.com/onlinehelp/k2blackpearl/devref/4.6.6/webframe.html_general - ado.net overview.html
Some example query:-
SELECT * FROM [Smartobject].[Method] HAVING [Parameter] = [Value]
Remember to use "HAVING" clause instead of "WHERE" clause.