Custom report/query in Activiti Explorer

[mchaia]

Hi,
I'd like to integrate a custom query into Explorer in order to show data from Activiti history tables.
I know I can view all tables but I need something more elaborated (i.e. select & join).
Users are using Explorer but when they want to get some structured information about completed task I have to make a report for them (i.e. connect to the DB, run my query and send an email with the results).
I would like to avoid writing an extra application just for those 2 or 3 reports.
Is that possible? Are there other options?

Thanks in advance,
Martin

[ronald_van_kuij]

Sure, you can change the sourcecode of te explorer, recompile and deploy it and you are set… Keep in mind though that with each updat of the explorer, you have to add your code again…

[amanpsc]

I tried doing that but I do not see the report. What am I missing here?
- I checked out activiti-webapp-explorer2, made changes to db.properties.
- Created a report XML file and registered it by ".addClasspathResource("org/activiti/explorer/demo/process/reportTest.xml")" in DemoDataConfiguration.java
- Rebuilt the artifact and deployed it.
But could not see the reportTest in activiti-explorer