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.
For regular information become a member in the Developer Partner Community please register here.