topic When extending the ListOfValuesConstraint with an id,name structure, how do you modify the search element so that you can search using the name rather than the id? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/when-extending-the-listofvaluesconstraint-with-an-id-name/m-p/28675#M12230 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have successfuly created a dynamic list constraint by extending the ListOfValuesConstraint.</P><P>The database table (custom_entities) has two columns (id,name) as follows:<BR /><STRONG>id, name</STRONG><BR />1, EntityA<BR />2, EntityB<BR />3, EntityC<BR />...</P><P></P><P>The property stores the id value (1), but share shows the name label (EntityA) throughout. &nbsp;This is how you would expect it to work.</P><P></P><P></P><P>However, I am not sure how to make the search work.</P><P>For example the following search will find all Entities with id 1:</P><P>ukl:entity:'1'</P><P>However I want a way to be able to use the name field, like so:</P><P>ukl:entity:'EntityA'</P><P>Since the id is the only value stored clearly this won't work out of the box.</P><P></P><P>Can somebody please provide some suggestions on a potential way forward with this?</P><P>I want to avoid using the name field as reference, which would have been the easy way out.</P><P></P><P><STRONG>Best Regards,</STRONG></P><P></P><P><STRONG>Adam</STRONG></P><P></P><PRE class="language-java line-numbers"><CODE><SPAN class="comment token">// ListOfEntitiesConstraint</SPAN><BR /><SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">ListOfEntitiesConstraint</SPAN> <SPAN class="keyword token">extends</SPAN> <SPAN class="token class-name">ListOfValuesConstraint</SPAN> <SPAN class="keyword token">implements</SPAN> <SPAN class="token class-name">Serializable</SPAN> <SPAN class="punctuation token">{</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">static</SPAN> <SPAN class="keyword token">final</SPAN> <SPAN class="keyword token">long</SPAN> serialVersionUID <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">private</SPAN> List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> allowedLabels<SPAN class="punctuation token">;</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">setAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN>List allowedValues<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">setCaseSensitive</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">boolean</SPAN> caseSensitive<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">initialize</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">super</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">setCaseSensitive</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token boolean">false</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">loadDB</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> <SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">loadDB</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">super</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> <SPAN class="token function">getAllowedLabels</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN>allowedLabels<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">setAllowedLabels</SPAN><SPAN class="punctuation token">(</SPAN>List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> allowedLabels<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN>allowedLabels <SPAN class="operator token">=</SPAN> allowedLabels<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> List<SPAN class="operator token">&lt;</SPAN>SelectItem<SPAN class="operator token">&gt;</SPAN> <SPAN class="token function">getSelectItemList</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List<SPAN class="operator token">&lt;</SPAN>SelectItem<SPAN class="operator token">&gt;</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ArrayList</SPAN><SPAN class="operator token">&lt;</SPAN>SelectItem<SPAN class="operator token">&gt;</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">size</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">int</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token">&lt;</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">size</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; result<SPAN class="punctuation token">.</SPAN><SPAN class="token function">add</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">SelectItem</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>Object<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">get</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN>allowedLabels<SPAN class="punctuation token">.</SPAN><SPAN class="token function">get</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> result<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; @Override<BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">public</SPAN> String <SPAN class="token function">getDisplayLabel</SPAN><SPAN class="punctuation token">(</SPAN>String constraintAllowableValue<SPAN class="punctuation token">,</SPAN> MessageLookup messageLookup<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">!</SPAN><SPAN class="keyword token">super</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">contains</SPAN><SPAN class="punctuation token">(</SPAN>constraintAllowableValue<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> null<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String message <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedLabels</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">get</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">super</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">getAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">indexOf</SPAN><SPAN class="punctuation token">(</SPAN>constraintAllowableValue<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> message <SPAN class="operator token">==</SPAN> null <SPAN class="operator token">?</SPAN> constraintAllowableValue <SPAN class="operator token">:</SPAN> message<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">//return super.getDisplayLabel(constraintAllowableValue, messageLookup);</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">protected</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">loadDB</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String driverName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"org.postgresql.Driver"</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String serverName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"alfresco.meab.local"</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String mydatabase <SPAN class="operator token">=</SPAN> <SPAN class="string token">"alfresco"</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String username <SPAN class="operator token">=</SPAN> <SPAN class="string token">"postgres"</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String password <SPAN class="operator token">=</SPAN> <SPAN class="string token">"password"</SPAN><SPAN class="punctuation token">;</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> av <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ArrayList</SPAN><SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List<SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN> al <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ArrayList</SPAN><SPAN class="operator token">&lt;</SPAN>String<SPAN class="operator token">&gt;</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR /><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Connection connection <SPAN class="operator token">=</SPAN> null<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Class<SPAN class="punctuation token">.</SPAN><SPAN class="token function">forName</SPAN><SPAN class="punctuation token">(</SPAN>driverName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String url <SPAN class="operator token">=</SPAN> <SPAN class="string token">"jdbc:postgresql://"</SPAN> <SPAN class="operator token">+</SPAN> serverName <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> mydatabase<SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; connection <SPAN class="operator token">=</SPAN> DriverManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">getConnection</SPAN><SPAN class="punctuation token">(</SPAN>url<SPAN class="punctuation token">,</SPAN> username<SPAN class="punctuation token">,</SPAN> password<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Statement stmt <SPAN class="operator token">=</SPAN> connection<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createStatement</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ResultSet rs <SPAN class="operator token">=</SPAN> stmt<SPAN class="punctuation token">.</SPAN><SPAN class="token function">executeQuery</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"select id, name from custom_entities order by name ASC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">while</SPAN> <SPAN class="punctuation token">(</SPAN>rs<SPAN class="punctuation token">.</SPAN><SPAN class="token function">next</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; av<SPAN class="punctuation token">.</SPAN><SPAN class="token function">add</SPAN><SPAN class="punctuation token">(</SPAN>rs<SPAN class="punctuation token">.</SPAN><SPAN class="token function">getString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"id"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; al<SPAN class="punctuation token">.</SPAN><SPAN class="token function">add</SPAN><SPAN class="punctuation token">(</SPAN>rs<SPAN class="punctuation token">.</SPAN><SPAN class="token function">getString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"name"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e<SPAN class="punctuation token">.</SPAN><SPAN class="token function">printStackTrace</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">super</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">setAllowedValues</SPAN><SPAN class="punctuation token">(</SPAN>av<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">setAllowedLabels</SPAN><SPAN class="punctuation token">(</SPAN>al<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">}</SPAN><BR /><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</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><P></P><PRE class="line-numbers language-markup"><CODE><SPAN class="comment token">&lt;!-- Relevant parts of model --&gt;</SPAN><BR />...<BR /><SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>constraints</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>constraint</SPAN> <SPAN class="attr-name token">name</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>ukl:entityList_constraint<SPAN class="punctuation token">"</SPAN></SPAN> <SPAN class="attr-name token">type</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>com.acme.cmspoc2.demoamp.ListOfEntitiesConstraint<SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>parameter</SPAN> <SPAN class="attr-name token">name</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>allowedValues<SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>list</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>list</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>parameter</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>parameter</SPAN> <SPAN class="attr-name token">name</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>caseSensitive<SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>value</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>true<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>value</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>parameter</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>constraint</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR /><SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>constraints</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />...<BR /><SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>type</SPAN> <SPAN class="attr-name token">name</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>ukl:doc<SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>title</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>General Document<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>title</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>parent</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>cm:content<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>parent</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>properties</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>property</SPAN> <SPAN class="attr-name token">name</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>ukl:entity<SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>title</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>Entity<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>title</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>type</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>d:text<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>type</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>multiple</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>true<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>multiple</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>constraints</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;</SPAN>constraint</SPAN> <SPAN class="attr-name token">ref</SPAN><SPAN class="attr-value token"><SPAN class="punctuation token">=</SPAN><SPAN class="punctuation token">"</SPAN>ukl:entityList_constraint<SPAN class="punctuation token">"</SPAN></SPAN> <SPAN class="punctuation token">/&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>constraints</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>property</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>properties</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...<BR /><SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token">&lt;/</SPAN>type</SPAN><SPAN class="punctuation token">&gt;</SPAN></SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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></CODE></PRE></BODY></HTML> Tue, 02 May 2017 01:35:32 GMT adamparker 2017-05-02T01:35:32Z When extending the ListOfValuesConstraint with an id,name structure, how do you modify the search element so that you can search using the name rather than the id? https://connect.hyland.com/t5/alfresco-forum/when-extending-the-listofvaluesconstraint-with-an-id-name/m-p/28675#M12230 Hi All,I have successfuly created a dynamic list constraint by extending the ListOfValuesConstraint.The database table (custom_entities) has two columns (id,name) as follows:id, name1, EntityA2, EntityB3, EntityC...The property stores the id value (1), but share shows the name label (EntityA) throug Tue, 02 May 2017 01:35:32 GMT https://connect.hyland.com/t5/alfresco-forum/when-extending-the-listofvaluesconstraint-with-an-id-name/m-p/28675#M12230 adamparker 2017-05-02T01:35:32Z Re: When extending the ListOfValuesConstraint with an id,name structure, how do you modify the search element so that you can search using the name rather than the id? https://connect.hyland.com/t5/alfresco-forum/when-extending-the-listofvaluesconstraint-with-an-id-name/m-p/28676#M12231 <HTML><HEAD></HEAD><BODY><P>In short, there is no way to achieve this. The value is just the id, so you must use that for search. For the user you will almost always provide this via a select list that uses the name for the display label, so it is not an issue. For the developer - well, they will just have to use the correct value when writing a query.</P></BODY></HTML> Tue, 02 May 2017 20:48:35 GMT https://connect.hyland.com/t5/alfresco-forum/when-extending-the-listofvaluesconstraint-with-an-id-name/m-p/28676#M12231 afaust 2017-05-02T20:48:35Z