Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to do Predictive search in reports like google

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] How to do Predictive search in reports like google
 Login/Join
 
MH
Member
posted
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
 
Posts: 11 | Registered: October 13, 2010Report This Post
ABT
Master
posted Hide Post
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.

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
MH
Member
posted Hide Post
Hi,
I did not get a chance to try this. Will updates status later.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 11 | Registered: October 13, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to do Predictive search in reports like google

Copyright © 1996-2020 Information Builders