topic How to query database for candidateUsers in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-query-database-for-candidateusers/m-p/212144#M165274 <HTML><HEAD></HEAD><BODY><SPAN>I need to dynamically query the list of candidateUsers/candidateGroups from database. Can this be done?</SPAN><BR /><BR /><SPAN>I tried the following:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />package com.mastersam.adama.server.activiti.delegate;<BR /><BR />import org.slf4j.Logger;<BR />import org.slf4j.LoggerFactory;<BR /><BR /><BR />public class CandidateGroupDelegate {<BR />&nbsp;&nbsp;&nbsp; private Logger logger = LoggerFactory<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .getLogger(CandidateGroupDelegate.class);<BR /><BR />&nbsp;&nbsp;&nbsp; public String getGroup() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.error("getGroup");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return "requester";<BR />&nbsp;&nbsp;&nbsp; }<BR />}<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Then I have this in my activiti-context.xml</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&lt;property name="beans"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;map&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;entry key="candidateGroupDelegate" value-ref="candidateGroupDelegate" /&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/map&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />…<BR />&lt;bean id="candidateGroupDelegate"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="com.mastersam.adama.server.activiti.delegate.CandidateGroupDelegate"&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>After which I set in the candidateUsers property of the Process</SPAN><BR /><BR /><SPAN>${candidateGroupDelegate.getGroup()} </SPAN><BR /><BR /><SPAN>or </SPAN><BR /><BR /><SPAN>#{candidateGroupDelegate.getGroup()}</SPAN><BR /><BR /><SPAN>both doesn't work, it doesn't call my function. </SPAN><BR /><BR /><SPAN>I tried searching and it doesn't seems like the candidateUsers and candidateGroups parameter supports spring expression, is that right?</SPAN><BR /><BR /><SPAN>Any other ways to accomplish what I want?</SPAN></BODY></HTML> Thu, 19 Nov 2015 09:31:14 GMT ykphuah 2015-11-19T09:31:14Z How to query database for candidateUsers https://connect.hyland.com/t5/alfresco-archive/how-to-query-database-for-candidateusers/m-p/212144#M165274 I need to dynamically query the list of candidateUsers/candidateGroups from database. Can this be done?I tried the following<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ackage com.mastersam.adama.server.activiti.delegate;import org.slf4j.Logger;import org.slf4j.LoggerFactory;public class CandidateGroupDelegate {&nbsp;&nbsp;&nbsp; private Logger logger = Lo Thu, 19 Nov 2015 09:31:14 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-database-for-candidateusers/m-p/212144#M165274 ykphuah 2015-11-19T09:31:14Z Re: How to query database for candidateUsers https://connect.hyland.com/t5/alfresco-archive/how-to-query-database-for-candidateusers/m-p/212145#M165275 <HTML><HEAD></HEAD><BODY><SPAN>I noticed that this works for the candidateGroups parameter in UserTask, but not for the candidateStarterGroups in the process. </SPAN></BODY></HTML> Thu, 19 Nov 2015 10:22:17 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-query-database-for-candidateusers/m-p/212145#M165275 ykphuah 2015-11-19T10:22:17Z