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     Drop Down List Box Multiple Selection

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Drop Down List Box Multiple Selection
 Login/Join
 
Rick Man
Platinum Member
posted
I am not able to set up multiple selections in a drop list in the HTMLPAINTER. Any suggestions or known issues. Also assuming I am missing something after the user presses go, what can I expect to have returned to my fex? I have seen posts that talk about a WHERE clause and others that pass the count in the &VAR0 variable and then the data in the &varx variables.

Thanks for you help.


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report This Post
dballest
Platinum Member
posted Hide Post
There should be a Multiple property of the drilldown (valid values: Not Set or Multiple).

As far as passing the parameter, it depends on your requirement. If you need to pass the whole list, you can write some jave script to parse it in the format so you can use it as an IN statement in your WHERE clause.


Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE
 
Posts: 197 | Location: Roseville, CA | Registered: January 24, 2005Report This Post
Martin
Member
posted Hide Post
Hi Rick,

After you will have the the "multiple" property it is possible that it's still not working. To make it work go in the HTML code then find the "SELECT" row of your id and add << operation="OR" >> on the line (if the multiple apply with an "OR", you can also put an "AND").

See example below:

<SELECT id=STORE style="Z-INDEX: 88; LEFT: 40px; WIDTH: 60px; POSITION: absolute; TOP: 235px; HEIGHT: 70px" tabIndex=5 multiple size=3 name=STORE addalloption="0" accept="0" datatype="0" datafieldtype="INTIGER" sourcetype="typeMaster" requiredfield="1436578" newchainnumber="0" IBIMR_domain="financed/financed.htm" IBIMR_folder="#reportsj471g" labelid="text8" [b]operation="OR"[/b]>


Hope that will complete dballest reply and make your multiple selection working.

This message has been edited. Last edited by: Kerry,


WF 7.6.11 HF4 gen34, WF 7.7.03 gen 253,
Windows 64 bit
Excel, PDF, HTML
 
Posts: 18 | Registered: December 06, 2007Report This Post
susannah
Expert
posted Hide Post
rick, we just discussed this very issue yesterday.
here's the thread.
All our existing code has to be rewritten.
its awful. the version 7 htmlpainter makes the narrow-minded and erroneous assumption that a launch page runs a single fex with a single filter.
So we wrote a chunk of code to unwind that, and put it back to the way it works for all our existing code. That code is in the thread i pointed you to. Take, tweak, improve, and report back on how you're doing.
-S.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Larry Doley
Member
posted Hide Post
If you've built the report in report painter in developer studio IBI now handles all that for you. No more dialogue manager to loop through and develop your where clause.

Take a look at the source code to see the combination of html javascript and xml that does it. Nice.
 
Posts: 9 | Registered: August 20, 2007Report This Post
susannah
Expert
posted Hide Post
Larry, that's just it. it doesn't anymore.
it changed from separate variables to a single complex filter.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
susannah
Expert
posted Hide Post
banging head on wall.
you've missed the point.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Rick Man
Platinum Member
posted Hide Post
Thanks.
Report Painter is where I needed to create the multiple selection function not HTML Painter.
It then create a WHERE FIELD EQ 'A' OR 'B' OR etc. clause.


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
 
Posts: 204 | Registered: March 31, 2008Report 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     Drop Down List Box Multiple Selection

Copyright © 1996-2020 Information Builders