Live Combo Search with ExtJS
If you trying to list thousands of data in a combobox, then you have a problem. I faced this problem a while ago. I was developing the presentation layer with ExtJS. ExtJS has a live search solution for this situation. Check the web page: http://extjs.com/deploy/dev/examples/form/forum-search.html
I will explain the whole story from beginning to end about this online dynamic checkbox control. I will use Oracle XE 10g, Java-Struts with JPS pages and ExtJS. We will pass the data with JSON. You may make some changes in the code. It all depends on you. My metod is just a suggestion.
Lets create a procedure that returns a cursor. It also takes an input parameter that’s our search string. We have 60000 rows in table company. It is also recommended to create an Function-Based Index (FBI) on “lower(t. company_name)”.