How to pass two input parameters for a RANGE via CE_PROJECTION

[patrickbachmann]

Hello friends,

Ok now my next input parameter challenge is passing two input parameters to my CE_PROJECTION inside my SQL script calculation view to simulate a RANGE;

For example I have a parameter for StartYear and a second parameter for EndYear.

I have tried various syntax such as this;

var_out = CE_PROJECTION ( :vartable, ["MENGE" As TOTALQUANTITY, "MJAHR"], '"MJAHR" between :StartYear and :EndYear');

Which does not work.  I get filter syntax error.

Suggestions?

Thanks!

-Patrick

[Former Member · Accepted solution]

You can't use between. You need to do:

var_out = CE_PROJECTION ( :vartable, ["MENGE" As TOTALQUANTITY, "MJAHR"], '"MJAHR" > :StartYear AND "MHAHR" < :EndYear');

John

[patrickbachmann · Accepted solution]

It worked!  So simple, I should have thought of it.  Thanks John!

-Patrick