Symptoms
Join Syntax for SmartObject ADO Query
Diagnoses
Join Syntax for SmartObject ADO Query
Resolution
You may refer to this documentation on ADO query syntax:(http://help.k2.com/onlinehelp/K2blackpearl/DevRef/current/default.htm_ADO.Net_Query.htm_tracksearch=ado query join
)
eg.
SELECT * FROM WorkflowReportingService_ActivityInstanceReport.ActivityInstanceDetail INNER JOIN WorkflowReportingService_UserPerformanceReport.UserPerformanceDetail ON WorkflowReportingService_ActivityInstanceReport.ActivityInstanceID= WorkflowReportingService_UserPerformanceReport.ActivityInstanceID HAVING WorkflowReportingService_UserPerformanceReport.ProcessSetFullName='PARAM1' AND WorkflowReportingService_UserPerformanceReport.ActivityName = 'PARAM2'
As a note, you would need to indicate the system name of the smartobject, its properties and also its methods. You may find the system name using the smartobject service tester.
