topic Re: Advanced Search/Reporting in Activiti in Alfresco Forum

Advanced Search/Reporting in Activiti

gbanks — Wed, 12 Jul 2017 14:06:25 GMT

In the Activiti Task App, I need to be able to filter for process instances with particular form field values, and within a particular date range. The user should then be able to view all results that match that query, and be able to enter the process instance overview to see all information/files s

Re: Advanced Search/Reporting in Activiti

ryandawson — Fri, 14 Jul 2017 13:43:35 GMT

I'm not sure exactly which version you're using but the general theme with Activiti reporting is that certain basic reports are provided with the intention that any custom reports can then be added as desired. For a bit of an overview of reporting and why the version matters see - Need Help in creating Activiti Custom Reports

Re: Advanced Search/Reporting in Activiti

gbanks — Fri, 14 Jul 2017 14:22:02 GMT

I may be mistaken, but in my research of Custom Reports I found that it only allowed certain parameters to be added. I would need to be able to query on potentially every form field value

Re: Advanced Search/Reporting in Activiti

ryandawson — Fri, 14 Jul 2017 15:21:02 GMT

It depends whether you're looking at enterprise or community. If you're looking at enterprise then you could look at GitHub - Alfresco/activiti-custom-reports: Example custom Analytics reports for Alfresco Activiti . If community then you might be best to look at Reporting capabilities in Activiti 5.12 | Small steps with big feet (perhaps considering the idea of using the java query API as it may be that a query like could meet your needs better than having to write SQL).

Re: Advanced Search/Reporting in Activiti

gbanks — Fri, 14 Jul 2017 16:18:59 GMT

I'm just trying to build tabular reports. Is there a way to also display the files that are attached in a process instance?

Re: Advanced Search/Reporting in Activiti

ryandawson — Fri, 14 Jul 2017 17:11:59 GMT

That sounds like quite an involved requirement that would probably require some kind of ETL. For an example you could have a look at GitHub - cijujoseph/activiti-analytics-spring-boot: A standalone app (ETL pattern using spring-boot) that extracts proce…