Focal Point
[CLOSED] Composer Multiselect limits values to five only

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5687078276

September 29, 2014, 11:22 AM
FOCdeveloper
[CLOSED] Composer Multiselect limits values to five only
Hi All
I have a Multiselect Parameter set to a Control using external procedure to pass the values..
It shows only 5 values after I select more than 5..
Is there something I missed, or Composer behaving BAD.. Box "Limit Values to" is not clicked .. I also tried having Clicked with values to 100 and it still shows 5 values only

I am still using 7.6.11
Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
September 29, 2014, 11:48 AM
MartinY
What do you mean by :
quote:
It shows only 5 values after I select more than 5..
? Where does it only show 5, on screen ? Does your control large enough to display more than 5 on screen ?

Provide your code, it may help us helping you.


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
September 29, 2014, 12:18 PM
FOCdeveloper
Thanks Martin

Control Box shows Location (there are more than 100 locations)
User should be able to select one or more than 1 location.
I do a -? & in the fex that gets run when you do a submit, to see what values are being passed from the Launch page.. I see for Location parameter, it only shows up to 5, when I selected more than 5..

  
-? &
-EXIT


Following is what shows whats coming from launch Page after I select 8 locations and submitting it
'000257' OR '000271' OR '000025' OR '000248' OR '000274' OR '


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
September 29, 2014, 12:22 PM
FOCdeveloper
Control Box is Fine, it shows shows the values.. its when you select more than 5, the resulting parameter seems to run out of space..

I selected three locations and it shows three
&LOCPARAM = '000271' OR '000025' OR '000248'


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
September 29, 2014, 01:15 PM
Francis Mariani
What does the full URL look like? Are these values at the end of the URL and perhaps the URL is getting truncated? If you're using a form, can you set the form method to post instead of get?

It's been a while since I've worked with v7.6.11...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 29, 2014, 01:31 PM
MartinY
Displaying a variable has a limited space. You probably receive the whole thing, it's just that it's not all displayed with -? &.

Try -TYPE &yourvarname

Even that will only show a few characters but more than -? &

The better way to see if all is passed is using something like :

SET XRETRIEVAL = OFF
TABLE FILE xx
WHERE column EQ &yourvarname;
END
-EXIT


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
September 29, 2014, 03:01 PM
FOCdeveloper
Thank you Martin.. You are correct.. I tried -TYPE and using WHERE.. both seems to display the same number of values..

Thanks Francis URL does not show much http://SeverName/ibi_apps/WFServlet


Prod/Dev/Test: WF 8.1.5 on (Windows Server 2012 R2 )
SandBox: WebFocus Server 8.1.5 on Windows Server 2008 R2
WebFOCUS App Studio 8.1.5 and Developer Studio 8.1.5 on Windows 7
September 30, 2014, 06:35 AM
Rifaz
Can you give us both of your code, which is used for the control & report?


-Rifaz

WebFOCUS 7.7.x and 8.x
October 10, 2014, 03:44 PM
Tony A
quote:
Following is what shows whats coming from launch Page after I select 8 locations and submitting it'000257' OR '000271' OR '000025' OR '000248' OR '000274' OR '


Just because your -? & statement doesn't show the entire string of the variable value, doesn't mean that it is limiting you to 5 values.

Consider this code, even though the -? & only shows the first 5 values, the underlying value of the variable is still as per -SET command.

The real problem is the limited length of display from -? & which has been like that since early days of using that command.

-SET &MULTIVAR = '''000257'' OR ''000271'' OR ''000025'' OR ''000248'' OR ''000274'' OR ''000275'' OR ''000276'' OR ''000277''';

-TYPE &MULTIVAR

-? &MULT

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