topic Re: Custom Report in Enterprise Activiti in Alfresco Forum

Custom Report in Enterprise Activiti

durai — Tue, 02 May 2017 18:56:24 GMT

Hi,We are using Enterprise Activiti 1.5, wanted to create custom report by allowing user to select/enter input parameter and generate report for that parameter. Looked into "activiti-custom-reports" in github but that doesn't accept any parameters from the user. I see in documentation suggesting to

Re: Custom Report in Enterprise Activiti

gdharley — Wed, 03 May 2017 22:56:22 GMT

Yup, something else Alfresco forgot to document.

Took a little bit of playing around but it turns out it is pretty easy.

The following definition:

@Override
public ParametersDefinition getParameterDefinitions(Map<String, Object> parameterValues) {
    ParametersDefinition definition = new ParametersDefinition();
    definition.getParameters().add(new Parameter("processDefinitionId", null, "processDefinitionId", Parameter.TYPE_PROCESS_DEFINITION, parameterValues.get("processDefinitionId")));
    definition.getParameters().add(new Parameter("includeCompleted", null, "includeCompleted", Parameter.TYPE_BOOLEAN, parameterValues.get("includeCompleted")));
    return definition;
}

Results in the following report parameter view:

There are a limited number of available search parameters in the Parameter class:

public static final String TYPE_DATE = "date";
public static final String TYPE_DATE_RANGE = "dateRange";
public static final String TYPE_DATE_INTERVAL = "dateInterval";
public static final String TYPE_DURATION = "duration";
public static final String TYPE_PROCESS_DEFINITION = "processDefinition";
public static final String TYPE_TASK = "task";
public static final String TYPE_STATUS = "status";
public static final String TYPE_INTEGER = "integer";
public static final String TYPE_BOOLEAN = "boolean";

So make sure your queries are formed to make use of the available types.

The special types such as TYPE_PROCESS_DEFINITION, TYPE_TASK, TYPE_STATUS will auto populate with available task names, process definition names and process instances status's from the elasticseach repo.

Hope this gets you where you need to be.

Greg

‌

Re: Custom Report in Enterprise Activiti

durai — Thu, 04 May 2017 12:29:42 GMT

Greg,

Thank you for the code it worked.

Question, so we can have only the predefined types as parameters? our requirement is, list all the users in the drop-down and on-select of the user display all the workflows started by that selected user. Is it possible? Please let me know.

-Durai

Re: Custom Report in Enterprise Activiti

gdharley — Thu, 04 May 2017 12:52:40 GMT

Dural,

Unfortunately there is nothing "open" about Enterprise Edition.

I had to retrieve the source from Alfresco's private nexus repo in order to investigate this question.

Had I not had access, I would not have been able to answer (short of decompiling the classes).

That said, the only available parameter options are those I posted.

Could we add new options? Certainly, we could overload the Parameter class as well as the report renderer library to be able to understand the new parameter. In fact, that is the sort of work my company (BP3) does.

Alternatively, you could open a feature request with Alfresco.

Let me know if you want to investigate an enhancement through BP3.

Thanks,
Greg

‌

Re: Custom Report in Enterprise Activiti

durai — Thu, 04 May 2017 14:00:21 GMT

Greg,

Thank you for the quick reply!! will look into Alfresco classes and see how we can implement the additional parameters.

Regards,

Durai

Re: Custom Report in Enterprise Activiti

gdharley — Thu, 04 May 2017 16:30:16 GMT

Good luck with that. Keep in mind, any changes you make will need to be maintained and re-introduced when you upgrade.

Re: Custom Report in Enterprise Activiti

gbanks — Wed, 12 Jul 2017 19:49:02 GMT

Hey Greg, I see that the search parameters are indeed limited. Have you been able to set up report parameters based on the variables within a process? E.g. a process includes a form where "Company Name", "Payment Amount", etc are entered. I'd like to be able to create a report where these values can be filtered. Company Name = x. Payment amount >= 500. Payment Amount < 1,000

Re: Custom Report in Enterprise Activiti

gdharley — Wed, 12 Jul 2017 20:00:28 GMT

Hey Greer,

Unfortunately the list of available parameter types does not include process variables.

Below is the list I have taken from source:

And, the report parameter types dont appear to have been built in a way that we can extend easily.

So, it kind of makes the out of box reporting a little anemic.

What is interesting though is a github project that Ciju Joseph (an Alfresco engineer) has built out that creates a different ElasticSearch repo and populates process instance data along with process variables. I havent tested, but you may be able to use Kibana or something similar to build out your reports from this repo.
Check it out here: GitHub - cijujoseph/activiti-analytics-spring-boot: A standalone app (ETL pattern using spring-boot) that extracts proce…

Cheers,

Greg