Developer Partner Community

Search Across Multiple Columns in a SelectSingle by Shay Shmeltzer

Juergen Kress
PaaS Partner Adoption


The new oj-selectSingle component is the recommended component for selection lists in Visual Builder starting with version 20.10. In past blog entries we showed you some of the advance features it offers such as advanced layouts and retrieving additional values beyond just the label. In this blog we show you one more capability - searching for a value across multiple columns in the list.

To achieve this capability you'll need to populate your singleSelect using an Array Data Provider - this keeps the records fetched on the client, and enables you to search across the array of data.

Array Data Provider has an attribute called textFilterAttributes that you can specify in its definition and will contain an array listing the fields that you want to allow searching on (make sure they are fetched when you populate the ADP). One tricky part, right now, is that we don't expose the textFilterAttributes attribute in the VB design time, so you need to switch into code view the page's json file, locate the variable definition, and update it directly there. You can see an example of this in the JET cookbook here, and the code I specifically used for the JSON file is: Read the complete article here.


Developer Partner Community

For regular information become a member in the Developer Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook image Meetups

Technorati Tags: PaaS,Cloud,Middleware Update,WebLogic, WebLogic

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.