topic 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? in Alfresco Forum

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?

adamparker — Tue, 02 May 2017 01:35:32 GMT

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

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?

afaust — Tue, 02 May 2017 20:48:35 GMT

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.