topic Multiple OR Statement in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/multiple-or-statement/m-p/177835#M130965 <HTML><HEAD></HEAD><BODY><SPAN>Hi everybody,</SPAN><BR /><BR /><SPAN>I'm trying to do an HistoricProcessInstanceQuery with multiple OR. </SPAN><BR /><BR /><SPAN>My use case is the following :</SPAN><BR /><BR /><SPAN>- I have multiple instances of process with 2 variables A and B. Values for A can be 1, 2, 3 and values for B can be 5,6,7. </SPAN><BR /><SPAN>- I'm trying to find process instances with variables (A1 OR A2) AND (B5 OR B7).</SPAN><BR /><BR /><SPAN>I'm totally blocked. My request can be (A1 OR A2 OR B5 OR B7) or (A1 AND A2 AND B5 AND B7) … but this is not the way I've to implement my business requirement.</SPAN><BR /><BR /><SPAN>Could you please advise me on this case ? I really don't understand why it's impossible to have multiple OR statements in one query ?</SPAN><BR /><BR /><SPAN>Thanks a lot,</SPAN></BODY></HTML> Tue, 30 Jun 2015 20:56:25 GMT mysterejack 2015-06-30T20:56:25Z Multiple OR Statement https://connect.hyland.com/t5/alfresco-archive/multiple-or-statement/m-p/177835#M130965 Hi everybody,I'm trying to do an HistoricProcessInstanceQuery with multiple OR. My use case is the following :- I have multiple instances of process with 2 variables A and B. Values for A can be 1, 2, 3 and values for B can be 5,6,7. - I'm trying to find process instances with variables (A1 OR A2) A Tue, 30 Jun 2015 20:56:25 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-or-statement/m-p/177835#M130965 mysterejack 2015-06-30T20:56:25Z Re: Multiple OR Statement https://connect.hyland.com/t5/alfresco-archive/multiple-or-statement/m-p/177836#M130966 <HTML><HEAD></HEAD><BODY><SPAN>In the javadoc of the or method the following statement is made about this:</SPAN><BR /><BR /><SPAN>Begin an OR statement. Make sure you invoke the endOr method at the end of your OR statement. Only one OR statement is allowed</SPAN><BR /><BR /><SPAN>So your use case is currently not supported ootb. You could use a native historic process instance query though and write the SQL yourself to make this work.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 01 Jul 2015 14:18:34 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-or-statement/m-p/177836#M130966 trademak 2015-07-01T14:18:34Z