How can the value being passed for the "ignore", of an html form (launch page: LP) control, be changed from "FOC_NONE" to something else, such as "All"?

I couldn't find anything here about this, a lot about ignore and FOC_NONE, but nothing about changing the returned value from FOC_NONE to [something else].

The reason I ask is that we have some SQL which is based on useing "ALL" in some of its filtering and the values, when selecting "ALL" from the LP is FOC_NONE. I want it to pass "ALL" I know that the &var_name_TEXT is available. But that would require code in the fex to use either the value of &var_name_TEXT or var_name, and I don't want to do that.

I'm looking forward to your thoughts on this.

BTW: I guess I could just change "ALL" to "FOC_NONE" in the SQL code but that brings in other issues and I'd prefer not going down that road.

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

If it's a static selection list, you should be able to add an option with 'ALL' as the value passed. If it's a dynamic list, you could add the 'ALL' option to the XML list in the focexec that creates the list.

Thanks Dan, It is a dynamic list which come from SQL pass thru. I can take those X records and do a TABLE FILE SQLOUT to create a N+1 record output. Is that what you're thinking? Got Samples, from CAR? I'll be back in the morning for more.

One idea:

SET HOLDLIST = PRINTONLY
SET ASNAMES  = ON
-*
FILEDEF CARHOLD DISK CARHOLD.FTM (APPEND
-RUN
DEFINE FILE CAR
 DISPLAY_TEXT/A13 = LCWORD(10,COUNTRY,'A13');
END
-*
TABLE FILE CAR
 SUM FST.DISPLAY_TEXT
 BY COUNTRY
 ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END
-*
-RUN
-SET &ALL_DISPLAY = 'All Countries';
-SET &ALL_VALUE = 'ALL       ';
-WRITE CARHOLD &ALL_VALUE..&ALL_DISPLAY
-RUN
-*
TABLE FILE CARHOLD
 SUM FST.DISPLAY_TEXT
 BY COUNTRY
 ON TABLE PCHOLD FORMAT XML
END

I Like it... Now I need to do that 18 times for this LP ...

What about setting the value on the launched fex?

-SET &SelVar = &SelVar EQ 'FOC_NONE' THEN 'ALL' ELSE &SelVar;

Just saying

sorry to reply to a closed topic, but in html composer you can change the default ignore by going to properties and clicking on the DOM dropdown >> DOCUMENT >> Ignor filters >> _FOC_NULL

Oh! That is in the GUI somewhere then... I've been manually fixing _FOC_NULL to FOC_NONE in several of our new launch pages already.

Well hidden!