Symptoms
Activity Instance Destination Smart Object
Diagnoses
Hello K2 Support,
I need to create Report in which I have to combine data from Activity Instance Destination Smart Object along with user defined Smart Object. I would like to know where the information of fields of Activity Instance Destination Smart Object is being used so I can write UNION Query and combine it with my Business Data and able to create Report.
Resolution
You can get the exact script by running a SQL Profiler trace.
You'll want to set the filters to only show the NTUserName of 'K2Service' or a LoginName of ''DOMANIN'K2Service. You'll also want to make sure that you select the 'TextData' column as output. Start the trace, fire of the smartobject, wait a few moments, and then stop the trace.
You'll be looking for exec sp_executesql N'WITH [_TempTable1] as (, and then the script will follow. You can highlight this row, and extract the event data.