topic List of values constraint from lucene or database search in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261053#M214183 <HTML><HEAD></HEAD><BODY><SPAN>Here is the code I use to retrieve a list of values constraint from a lucene search. It can easily be modified in order to execute the search against a database.</SPAN><BR /><BR /><SPAN>I still have a problem: getAllowedValues is called just once at Alfresco startup. So the result is not dynamic as I would like. Anyone has useful information to solve this issue?</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />package my.alfresco.constraint;<BR /><BR />import java.util.ArrayList;<BR />import java.util.Collection;<BR />import java.util.Collections;<BR />import java.util.List;<BR />import org.alfresco.model.ContentModel;<BR />import org.alfresco.repo.dictionary.constraint.ListOfValuesConstraint;<BR />import org.alfresco.service.cmr.repository.NodeService;<BR />import org.alfresco.service.cmr.repository.StoreRef;<BR />import org.alfresco.service.cmr.search.ResultSet;<BR />import org.alfresco.service.cmr.search.ResultSetRow;<BR />import org.alfresco.service.cmr.search.SearchService;<BR /><BR />public class LuceneSearchListConstraint extends ListOfValuesConstraint {<BR />&nbsp;&nbsp;&nbsp; private static NodeService nodeService;<BR />&nbsp;&nbsp;&nbsp; private static SearchService searchService;<BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; public void initialize() {<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; public List&lt;String&gt; getAllowedValues() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; allowedValues = getSearchResult();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; super.setAllowedValues(allowedValues);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return allowedValues;<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; private List&lt;String&gt; getSearchResult() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List&lt;String&gt; allowedValues = new ArrayList&lt;String&gt;();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String query = "PATH:\"/cm:generalclassifiable//cm:MyCategories/*\"";<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet resultSet = searchService.query(StoreRef.STORE_REF_WORKSPACE_SPACESSTORE, SearchService.LANGUAGE_LUCENE, query);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (ResultSetRow row : resultSet)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; allowedValues.add((String)nodeService.getProperty(row.getNodeRef(), ContentModel.PROP_NAME));<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Collections.sort(allowedValues);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (allowedValues.size() == 0)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; allowedValues.add("");<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return allowedValues;<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; @SuppressWarnings("unchecked")<BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; public void setAllowedValues(List allowedValues) {<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; public void evaluateCollection(Collection&lt;Object&gt; collection) {<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; public void setNodeService(NodeService nodeService) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LuceneSearchListConstraint.nodeService = nodeService;<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; public void setSearchService(SearchService searchService) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LuceneSearchListConstraint.searchService = searchService;<BR />&nbsp;&nbsp;&nbsp; }<BR /><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>‍</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><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>‍</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 /><SPAN>Required service and/or parameters are injected through a spring bean.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="LuceneSearchListConstraintInitializer" class="my.alfresco.constraint.LuceneSearchListConstraint"&gt; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="nodeService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;ref bean="nodeService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="searchService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;ref bean="searchService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&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></CODE></PRE><BR /><SPAN>Then the new constraint can be used within your model:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&lt;constraints&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;constraint name="my:myList" type="my.alfresco.constraint.LuceneSearchListConstraint"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;parameter name="allowedValues"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/parameter&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/constraint&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/constraints&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></CODE></PRE><BR /><SPAN>Best regards,</SPAN><BR /><SPAN>Alessandro</SPAN></BODY></HTML> Thu, 28 Jul 2011 06:43:05 GMT alarocca 2011-07-28T06:43:05Z List of values constraint from lucene or database search https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261053#M214183 Here is the code I use to retrieve a list of values constraint from a lucene search. It can easily be modified in order to execute the search against a database.I still have a problem: getAllowedValues is called just once at Alfresco startup. So the result is not dynamic as I would like. Anyone has Thu, 28 Jul 2011 06:43:05 GMT https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261053#M214183 alarocca 2011-07-28T06:43:05Z Re: List of values constraint from lucene or database search https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261054#M214184 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Did you find any solution? If so please post the solution</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Pavani Akella</SPAN></BODY></HTML> Mon, 05 Sep 2011 11:07:58 GMT https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261054#M214184 pavaniakella 2011-09-05T11:07:58Z Re: List of values constraint from lucene or database search https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261055#M214185 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Is this approach working for anyone? Populatinig the dropdown using List of Values Constraint code from datalist.</P></BODY></HTML> Mon, 15 Jul 2019 10:29:31 GMT https://connect.hyland.com/t5/alfresco-archive/list-of-values-constraint-from-lucene-or-database-search/m-p/261055#M214185 sandhya_nair 2019-07-15T10:29:31Z