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] Multi-select list box returns 'value1' NONE 'value2' NONE 'value3'

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Multi-select list box returns 'value1' NONE 'value2' NONE 'value3'
 Login/Join
 
SRC
Gold member
posted
I created a multi-select list box in html composer in 7.6.10. I select three values for the variable named VISA_TYPE and the return variable looks like this:

-TYPE VISA_TYPE=&VISA_TYPE
VISA_TYPE='F1' NONE 'J1' NONE 'C1'

Normally, I see this:

'F1' OR 'J1' OR 'C1'

I've never seen the word 'NONE' between the values in the variable.

Anyone know what this is?

Thanks................Steve

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


Dev Studio /7.6.11/7.7.02M
MVS/USS
AIX/SOLARIS
Windows WF Client 7.6.8/7.6.11
 
Posts: 64 | Location: Eastern and middle NC | Registered: March 13, 2007Report This Post
tkuhns
Member
posted Hide Post
Take a look at the source code and see if you find the following code in the select tag for the visa_type: operation="NONE"

This should be changed to: operation="OR" for the 'OR' to be in between the selected values.


WF 8.2, Dev Studio, DB2, MySQL, self-service
Output formats: HTML, Excel 2000 and PDF
 
Posts: 6 | Registered: July 14, 2010Report This Post
David Glick
Guru
posted Hide Post
Your FEX also needs to be set for multiselect. If it is not, we will show "NONE". You should open the report in the Report Painter and check the variable definition to make it Multiselect OR.

Then go back into HTML Composer and right-click on the report component and select "Refresh" to have it update with the changes.


David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com
 
Posts: 315 | Registered: April 13, 2004Report This Post
Norb Eckert
Platinum Member
posted Hide Post
David,

Can you point me to the IBI Javascript code that does the parsing? I'd like to use just that piece in another HTML page I have rather than build the page in HTML composer.

Thanks,

Norb


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
 
Posts: 242 | Location: Minneapolis | Registered: February 16, 2006Report This Post
SRC
Gold member
posted Hide Post
Thanks for the responses. I made the change in the HTML and it worked. If I open the HTML in composer, it changes it back to NONE. So I also added the

WHERE VISA_TYPE EQ &VISA_TYPE.(OR(FIND......
and that seems to work.

But I'm still a little confused because as I said initially, I've many times manually created a fex with input variables and then created an html page in composer which I next linked to the fex. Then I simple specify a multi-select list box and it usually defaults to 'OR'. We just upgraded to 7.6.10 so maybe the changed from OR to NONE is a default setting for the install.

At least now I know how to control it.

Thanks again................Steve


Dev Studio /7.6.11/7.7.02M
MVS/USS
AIX/SOLARIS
Windows WF Client 7.6.8/7.6.11
 
Posts: 64 | Location: Eastern and middle NC | Registered: March 13, 2007Report This Post
David Glick
Guru
posted Hide Post
Norb,

I'm sorry, but we do not support using our JavaScript directly since we may change it and then what was copied will not work anymore.

SRC,

I don't understand how "it worked" previously since we have always required the procedure to be multiselect and the control to be multiselect.


David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com
 
Posts: 315 | Registered: April 13, 2004Report This Post
Enigma006
Master
posted Hide Post
Same issue here. Never set any variables in report to make it multi select. Now getting this issue with NONE. though manually changed in the code, it againa goes back to NONE once opened in Composer..!! and also this issue happens very rarely. any solution?


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
David Glick
Guru
posted Hide Post
You have 2 choices. Either turn off "multiple" for the listbox in the HTML Composer, or fix the procedure to have a multiselect variable. The procedure and control must be in sync.


David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com
 
Posts: 315 | Registered: April 13, 2004Report This Post
Enigma006
Master
posted Hide Post
Thank you.
Can you please let me know how to make a variable multi selectable? I haven't done it before I guess or may be I did it but I don't know its this..

Thanks


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Tony A
Expert
posted Hide Post
Should be within the properties.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
David Glick
Guru
posted Hide Post
To make a variable multiselect, you can use the Variable Editor within the Report Painter. There is a Variable Type dropdown and you can select "Multiselect OR" for multiple values.

Then in HTML Composer, you select the "Multiple" property for the control.


David Glick
Director WebFOCUS App Studio
and WebFOCUS Developer Studio
WebFOCUS Division
Information Builders, Inc.
Direct (917) 339-5560
Voice Mail (212) 736-6250 x3560
Fax (212) 947-5168
Email david_glick@ibi.com
 
Posts: 315 | Registered: April 13, 2004Report 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] Multi-select list box returns 'value1' NONE 'value2' NONE 'value3'

Copyright © 1996-2020 Information Builders