[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 ThanksThis 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..
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