Focal Point
[CLOSED] 'All Values' not working properly in Auto-Parameter

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

August 03, 2018, 01:48 PM
Joshy
[CLOSED] 'All Values' not working properly in Auto-Parameter
Hi,
I am working on WF 8.2.02. I have an input parameter with multiselect option. When 'All Values' are selected, it shows No data instead of printing all the data,.
Find the example below, I understand that we can have a default settings to '_foc_null' for that parameter and fix this. But, I want to know the purpose of 'All values' in the parameter.


TABLE FILE GGSALES
SUM
DOLLARS
BY PRODUCT
WHERE PRODUCT EQ &PROD.(OR(FIND PRODUCT IN GGSALES)).PRD:.
END
-EXIT

Thanks.

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


WF 8.2.03
August 03, 2018, 03:53 PM
MartinY
It run fine in 8201M, I suggest that you open a case with TechSupport.


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
August 03, 2018, 05:36 PM
Joshy
Hi,

Thank you for checking. I have WF 8.2.03 in another machine. I tested there. It is working fine.

When I put ECHO=ALL and checked,
In 8.2.02, FOC_NONE is getting passed to the parameter, hence there is no data.
In 8.2.03, _FOC_NULL is passed to the parameter and generating all the data.

Whether we can change the settings in WF Server to modify this.

Thanks.


WF 8.2.03
August 04, 2018, 08:25 AM
BabakNYC
I think there’s a setting for this in the Admin Console. I can’t remember exactly where but it’s something you pick from a drop down.


WebFOCUS 8206, Unix, Windows
August 05, 2018, 10:42 AM
TobyMills
Hi Joshy,

See if this helps:


WebFOCUS Autoprompt Facility

Looks like the parameter you're after is called:
Null Behavior (IBIF_DESCRIBE_NULL)

Hope that helps!
Toby