I just want to report on K2 data, why is it so hard? :)
Had to abandon composite SmartObjects due to their poor design of retrieving all data first before applying filters, causing major performance issues. But we're not supposed to query the K2 database directly. So how the heck are we supposed to build reports on K2 data? What am I missing?
For example, I have some requirements now to build a report on all submitted form data, and I also want to report on their workflows. For example, "Start Date" and "Finish Date" of the Process Instance is available in the K2 database, albeit in different tables. I despite the idea of adding steps in my workflows to manually populate this data when I know it resides in the K2 database. Surely there must be some way?
