[SOLVED] Multiple default parameters using -DEFAULTH?

November 24, 2015, 02:06 PM

I'm using the WHERE statement in one of my charts:

 WHERE STORE_TBL.STORE_TBL.STORE EQ &STORE.(OR(FIND STORE_TBL.STORE_TBL.STORE IN STORE_TBL |FORMAT=A3V)).STORE:.;

I can set the store number to come up by default by setting the default:

 -DEFAULTH &STORE='''ALL''';

However, I need to default to stores 01, 07, and 08.

I've tried all of the versions of setting the default that I can think of and nothing will work such as:

 -DEFAULTH &STORE='''01''','''07''','''08'''

-DEFAULTH &STORE IN ( '01' , '07' , '08' )

Anyone have any ideas? Thanks!

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

November 24, 2015, 02:59 PM

CoolGuy

So, you want a parameter to default to an set of values instead of just a single value?

I've not done that myself in WF as of yet, and am unsure if that is even a thing either.

-DEFAULTH &VAR_ARRAY = value OR/AND value OR/AND value ???

November 24, 2015, 03:05 PM

j.gross

-DEFAULTH &STORE = ' ''01'', ''07'', ''08'' '

November 24, 2015, 03:12 PM

capples

I believe this should work (similar to j.gross's solution)

-DEFAULTH &STORE = '''01'' OR ''07'' OR ''08''';

November 24, 2015, 03:48 PM

Deej

quote:
-DEFAULTH &STORE = '''01'' OR ''07'' OR ''08''';

Thanks for the replies.

j.gross, yours threw a syntax error on the comma.
capples, yours worked! Thanks!