[CLOSED] How to do Predictive search in reports like google
Hi,
I am new on webfocus. I have to provide a filter on one column. It has filed called supplier name. It has more then 14000 reocrds. It is very difficult to load 14000 in a drop down list. It hangs when you run the report. Is it there any method to acheive this in webfocus or can we provide a predictive search like google as we type in. please let me know what is the best way to do this.This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
October 19, 2010, 01:24 PM
ABT
I'd search google for 'type ahead suggest ajax' r 'ajax type ahead example'. The key technology is executing a query using the onkeyup event and using Ajax/DHTML to populate the text box (or the canvas that looks like a drop-down box).
I'm guessing that you'll need a fex that queries a table based on user input and passes those results back to the HTML front end (using the onkeyup event). The HTML will use these returns to build a list of selectable output or take the first entry and populate it as is to the text box.
The technology seems to have progressed a long way since I last looked at how to do it, your best bet may be to use jQuery or one of the other javascript frameworks that seem to have a lot of the functionality already prebuilt. You should also be able to use one of the other examples around (ASP.NET, JSP, etc) to get a feel for how to implement in WF.