topic Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values. in Alfresco Forum

Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Wed, 20 Jun 2018 12:51:11 GMT

Hello,I have one process which has task and form fields. And I have one field "location" which I am considering as business key. For example, I have 2 locations as: India and UK. I want to fetch the process instances of these two locations. Means I need to pass the multiple business key values. Is

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Thu, 21 Jun 2018 08:04:41 GMT

I'm not sure I understood what are you trying to do. Do you want to do a query that returns process instances based on those values (form field values)?

Can you also specify whether you are using Activiti or APS and what version?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Thu, 21 Jun 2018 10:02:09 GMT

Yes. I want to do a query that returns process instances based on form field values.

I am using APS 1.7.

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Thu, 21 Jun 2018 11:23:12 GMT

You can query based on process variables values. For example,

POST api/enterprise/historic-process-instances/query

{"variables":[{"name":"myVar","value":"US","operation":"equals"}]}

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Fri, 22 Jun 2018 11:26:10 GMT

Thank youbassam.al-sarori for the solution. It worked for me. In my case I want to pass multiple values for the value. For example, I have to pass "US", "India", "UK" etc... as value. Is this possible to pass multiple values at once?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Tue, 26 Jun 2018 16:16:57 GMT

multiple values can be submitted using data tables.

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Wed, 27 Jun 2018 05:03:28 GMT

Can you please provide any example or documentation link?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Wed, 27 Jun 2018 08:38:10 GMT

Sorry I meant dynamic tables can be used for multiple values (rows).

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Wed, 27 Jun 2018 11:57:39 GMT

I want to fetch the process instances of multiple locations. For this I am using following swagger api:

http://localhost:8082/activiti-app/api-explorer.html#!/process-instances/getHistoricProcessInstancesUsingPOST

For this I have passed the process variable value as you suggested.

If I pass single location name then it is working properly.I am getting the process instances of that location . I have tested this in the postman. I am attaching here those screens:

Scenario 1: Fetching process instances of puna location(by variables [name as location and value as puna])

For this request I am getting following response[this location has 2 records[process instances] so I am getting those 2 records:

Scenario 2: Fetching process instances of banglore location(by variables [name as location and value as banglore])

For this request I am getting following response[this location has 3 records[process instances] so I am getting those 3 records:

Scenario 3: I want to fetch the process instances of these 2 locations [banglore and puna]. I am sending request as follows:

Ideally I should get the process instances of those 2 (bangloe and puna)locations. I should get 5 records in the response. But I am not getting any records but still response code is 200. I am getting the response as follows:

Why I am not getting the records if I pass multiple locations for variable value[Scenario 3]? Am I passing request in proper format or is there any other way to pass the multiple values for the variables for fetching the process instances?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Wed, 27 Jun 2018 12:40:50 GMT

The query will check for process instances that have all the variables included in the request.

{"variables":[
               {"name":"foo","value":"bar","operation":"equals"},
               {"name": "location", "value":"US", "operation":"equals"}
            ]
}

The above will return only processes that have both "foo" and "location" with the specified values. The query uses the "AND" clause.

You can create a custom REST endpoint that uses HistoricProcessInstanceQuery (Activiti - Engine 5.22.0 API)

historyService.createHistoricProcessInstanceQuery()
              .or()
                .variableValueEquals("location", "US")
              .endOr()
              .or()
                .variableValueEquals("location", "UK")
              .endOr()
              .list();

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Mon, 02 Jul 2018 12:08:44 GMT

I have created custom rest endpoint and added the query you suggested. But I am getting result as empty array even though I have records. I have written as follows:

@Timed
@RequestMapping(value = "/processInstances/{id}", method= RequestMethod.GET)
public String processInstances(@PathVariable String id) {

List<HistoricProcessInstance> processes = historyService.createHistoricProcessInstanceQuery()

.or()

.variableValueEquals("location", "banglore")

.endOr()

.or()

.variableValueEquals("location", "puna")

.endOr()

.list();
System.out.println("processes are as follows:\n");

System.out.println("get class"+processes);

return "INSIDE PROCESS INSTANCES..."+processes;
}

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Mon, 02 Jul 2018 13:02:56 GMT

My bad. The correct call should be like this.

historyService.createHistoricProcessInstanceQuery()
              .or()
                .variableValueEquals("location", "US")
                .variableValueEquals("location", "UK")
              .endOr()
              .list();

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Tue, 17 Jul 2018 07:44:02 GMT

Thank you Bassam Al-Sarori‌. It is working propelry. I am getting process instances of different locations. I also want to pass processDefinitionKey in the query. Means it should check those locations and also should check for that processDefinitionKey. And also I want number of records[number of process instances in the result]. Can you please provide solution?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Tue, 17 Jul 2018 08:29:35 GMT

You can add the process definition key to query like this (outside or endOr)

historyService.createHistoricProcessInstanceQuery()
              .processDefinitionKey("myKey")
              .or()
                .variableValueEquals("location", "US")
                .variableValueEquals("location", "UK")
              .endOr()
              .list();

To get results count you can use count() instead of list()

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

shilpak — Tue, 17 Jul 2018 09:52:43 GMT

Thank you. Is this possible to get response as list of records with size and total. Means I want all records and also the size and total number of records. Is this possible?

Re: Fetch the process instances by passing the multiple business key[processBusinessKey] values.

bassam_al-saror — Tue, 17 Jul 2018 10:13:47 GMT

Two queries will need to be executed. One for the count and another for the results. But both can be returned in the same response. You can use ResultListDataRepresentation<ProcessInstanceRepresentation> to get a similar response to what is returned by the standard REST query response.