topic Re: database queried constraints (text / drop down) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-queried-constraints-text-drop-down/m-p/207058#M160188 <HTML><HEAD></HEAD><BODY><SPAN>If you already have an efficient way of accessing the data, then you'll have to attach an onkeypress event listener that will submit a search. </SPAN><BR /><BR /><SPAN>If you don't want to make the service call for each keystroke, then you'll have to pass the entire list to the client on the original page load and perform the filtering there. </SPAN><BR /><BR /><SPAN>The latter approach would work better if the list is relatively static.</SPAN></BODY></HTML> Wed, 07 Oct 2009 15:26:51 GMT rliu 2009-10-07T15:26:51Z database queried constraints (text / drop down) https://connect.hyland.com/t5/alfresco-archive/database-queried-constraints-text-drop-down/m-p/207057#M160187 So I'm looking into querying our financial system to provide a list constraint for the "Vendor" field we are going to add to our purchasing documents.&nbsp; This seems easy based on code I've already found here, but the problem is that list will be very long.&nbsp; I'd like a control that works similar to the Tue, 05 May 2009 22:25:40 GMT https://connect.hyland.com/t5/alfresco-archive/database-queried-constraints-text-drop-down/m-p/207057#M160187 abruzzi 2009-05-05T22:25:40Z Re: database queried constraints (text / drop down) https://connect.hyland.com/t5/alfresco-archive/database-queried-constraints-text-drop-down/m-p/207058#M160188 <HTML><HEAD></HEAD><BODY><SPAN>If you already have an efficient way of accessing the data, then you'll have to attach an onkeypress event listener that will submit a search. </SPAN><BR /><BR /><SPAN>If you don't want to make the service call for each keystroke, then you'll have to pass the entire list to the client on the original page load and perform the filtering there. </SPAN><BR /><BR /><SPAN>The latter approach would work better if the list is relatively static.</SPAN></BODY></HTML> Wed, 07 Oct 2009 15:26:51 GMT https://connect.hyland.com/t5/alfresco-archive/database-queried-constraints-text-drop-down/m-p/207058#M160188 rliu 2009-10-07T15:26:51Z