topic ProcessInstanceQuery and runtime performance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/processinstancequery-and-runtime-performance/m-p/64277#M40495 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I defined a process that performs different tasks. During the execution of the process it evaluates new variables.</SPAN><BR /><SPAN>I have to show a web page with the list of processes that satisfy a certain condition on one of the variables.</SPAN><BR /><BR /><SPAN>I have successfully run a ProcessInstanceQuery().list() method with a filter on that variable</SPAN><BR /><SPAN>That method&nbsp; returns a list of ProcessInstance. </SPAN><BR /><SPAN>However the single element in the list contains only the id of the process instead I also need the value of a variable of the process.</SPAN><BR /><BR /><SPAN>I tried to cast the ProcessInstance to ExecutionEntity&nbsp; and use the method getVariabile("my var") but I get a "</SPAN><EM>lazy loading outside commandContext</EM><SPAN>" error.</SPAN><BR /><BR /><SPAN>The only alternative seems to loop on the list of results and execute a runtimeService.getVariable("my var") for each element.</SPAN><BR /><BR /><STRONG>Is there a better way to do this in a efficient way (not too many sql queries requests)?</STRONG><BR /><BR /><SPAN>best regards</SPAN></BODY></HTML> Thu, 20 Oct 2011 13:49:59 GMT kermit 2011-10-20T13:49:59Z ProcessInstanceQuery and runtime performance https://connect.hyland.com/t5/alfresco-archive/processinstancequery-and-runtime-performance/m-p/64277#M40495 Hi,I defined a process that performs different tasks. During the execution of the process it evaluates new variables.I have to show a web page with the list of processes that satisfy a certain condition on one of the variables.I have successfully run a ProcessInstanceQuery().list() method with a fil Thu, 20 Oct 2011 13:49:59 GMT https://connect.hyland.com/t5/alfresco-archive/processinstancequery-and-runtime-performance/m-p/64277#M40495 kermit 2011-10-20T13:49:59Z Re: ProcessInstanceQuery and runtime performance https://connect.hyland.com/t5/alfresco-archive/processinstancequery-and-runtime-performance/m-p/64278#M40496 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>You can write your own database queries to overcome this.</SPAN><BR /><SPAN>Else you're stuck with the runtimeservice getVariable method.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Fri, 21 Oct 2011 17:13:14 GMT https://connect.hyland.com/t5/alfresco-archive/processinstancequery-and-runtime-performance/m-p/64278#M40496 trademak 2011-10-21T17:13:14Z