topic Re: how to fetch process Definition all variables in Alfresco Forum

how to fetch process Definition all variables

amruta_w — Mon, 02 Dec 2019 12:50:27 GMT

Hello All,

I want to fetch all process Definition variables from process Definition Key !!

is there any documentation , API or Example please provide asap.

Re: how to fetch process Definition all variables

amruta_w — Wed, 04 Dec 2019 06:01:38 GMT

@bassam_al-saror please help me to find this. Thanks in advance.

Re: how to fetch process Definition all variables

abbask01 — Wed, 04 Dec 2019 14:43:25 GMT

you can only query varirables from a particular execution, create a native query instead of using the Java API

Re: how to fetch process Definition all variables

amruta_w — Thu, 09 Jan 2020 06:53:07 GMT

I am trying to get the process definition variables before creating the process instance, if you have worked like this scenario or any idea to get variables kindly help me out. Thanks in advance.

Re: how to fetch process Definition all variables

amruta_w — Fri, 10 Jan 2020 09:25:15 GMT

Hi @abbask01 ,

I have tried the following way to get variables from form table but i'm unable to get the variables, kindly help me out if have any idea

List<Execution> variables = runtimeService.createNativeExecutionQuery().sql("select _FORM.*" +
		        "  from  form _FORM" +
		        " where app_definition_id ="+appDefinitionId+" and name like '%closed edit readonly%'").list();
		List<Map<String, Object>> customTaskList = new ArrayList<>();
	    for (Execution vars : variables) {
	        Map<String, Object> map = new LinkedHashMap<>();
	        map.put("variableId", vars.getId());
	        map.put("variableName", vars.getName());
	        map.put("variableDescription", vars.getDescription());
	        customTaskList.add(map);
	    }
	    System.out.println("printing list");
	    customTaskList.forEach(System.out::println);

Thanks & Regards

Amruta Wandakar