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] Getting return and display values for a multiselect list from HTML Composer

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Getting return and display values for a multiselect list from HTML Composer
 Login/Join
 
tcwillden
Member
posted
Hey everyone, first official post here on the forum. I've been working on updating an existing BI portal that was created with the AppStudio HTML composer tool and we've encountered a problem with getting both the return and display values from a multi-select list box in the HTML form. We want to pass the return value through and have the display value appear in the header information for tables that viewers will see when querying information in the portal but it seems that the HTML composer/form will only let us send either the return or the display value, not both. Is there a way to send both in 8.2.02?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS: 8.2.02, OS: Windows 10
 
Posts: 4 | Registered: September 11, 2018Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
tcwillden

Welcome to Focal Point! I think you will find it a great place to get answers to your development questions.

I am not aware of a way to pass both but in the fex that runs you should be able to use dialog manager -SET commands to evaluate what was sent and then set another variable accordingly.

Like the following example...


-SET &DISPLAY_VALUE = IF &RETURN_VALUE EQ 'Something' THEN 'Something Else' ELSE IF &RETURN_VALUE EQ 'This' THEN 'That' ELSE 'Whatever';


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
tcwillden
Member
posted Hide Post
Thanks for responding! We've actually already used the -SET commands in the fex like you've described, but we're still having issues getting the display entry to appear in the header info and while having the return value pass through. We're hoping we don't have to, but we may need to use a DECODE statement to loop through the multi-select values

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


WebFOCUS: 8.2.02, OS: Windows 10
 
Posts: 4 | Registered: September 11, 2018Report This Post
CoolGuy
Virtuoso
posted Hide Post
Opinion:

It's totally "goofball" that we can't have both the return and display values passed into content from an HTML Composer form.

This functionality should have never been "fixed" the way it was. Ugh....


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Waz
Expert
posted Hide Post
What version of WebFOCUS are you using ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
tcwillden
Member
posted Hide Post
8.2.02


WebFOCUS: 8.2.02, OS: Windows 10
 
Posts: 4 | Registered: September 11, 2018Report This Post
Hallway
Master
posted Hide Post
I was able to pass both parameters with a little javascript. I just added an onClick event to the submit button then used jQuery to get the display value of each item in the multiselect and store it in a javaScript variable. Then passed that variable value to a hidden control that I added, and bound it to the amper variable in the report.
  
var eventObject = event ? event : window.event;
var ctrl = eventObject.target ? eventObject.target : eventObject.srcElement;
// TODO: Add your event handler code here

var ctrlDisplay = '';
var customselect1_selectto_ID = document.getElementById("customselect1_selectto");
var inputhidden1_ID = document.getElementById("inputhidden1");
var optn = '#' + $(customselect1_selectto_ID).attr('id') + ' option'

$.each( $( optn ), function( key, value) {
    ctrlDisplay = ctrlDisplay +  $(value).html() + ', ';
    } ); 

ctrlDisplay  = ctrlDisplay.slice(0, -2); 

console.log('Display: ' + ctrlDisplay );

$(inputhidden1_ID).val(ctrlDisplay);

}

//End function Submit_onclick


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Waz
Expert
posted Hide Post
HTML Composer allows the "text" of a selected value in a select list to be passed to a fex.

There is a setting called Send Display Value, under settings for the selected control.

Note: In 8.1.04 (not sure what other releases had the issue) , the parameter name was currupted, and when it tried to send {parmname}_TEXT it send _TEXT instead.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
MartinY
Virtuoso
posted Hide Post
quote:
There is a setting called Send Display Value, under settings for the selected control.

This return the displayed value ONLY not the code and the text.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Tony A
Expert
posted Hide Post
quote:
This return the displayed value ONLY not the code and the text.

Depends upon which release you mean.

Previously it did as Waz suggests but just checking 8.2.04 and it appears that this is no longer true?

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
CoolGuy
Virtuoso
posted Hide Post
In 8.2.02M, we will only ever get back either a return value or a display value. Can't have both unless you employ some convoluted workaround, per standard practices...lol

#cuzWeCantHaveNiceThingsInAppStudio #saveForTheOpenInAssociatedToolOption #bestThingTheyEVERadded


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report 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] Getting return and display values for a multiselect list from HTML Composer

Copyright © 1996-2020 Information Builders