Search Across Multiple Columns in a SelectSingle by Shay Shmeltzer


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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.