Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Optional input parameter in SQLScript based Calculation View

Hello guys.

Is any issue to pass optional input parameter in SQLScript based Calculation View?

Input box "Is mandatory" is disabled.

I try to pass character '*' to Input parameters and following SQLScript

SELECT f1,f2 from t1 where ( f1 = p1 and f2 = p2 and p1 <> '*' and p2 <> '*' ) or ( p1 = '*' and p2 = '*' )

But I get an error - Invalid column name p1 and p2.

BR, Marat.

Tags:
Former Member
Former Member replied

Sorry.

I made mistake and this SQLScript work fine

SELECT f1,f2 from t1 where ( f1 = p1 and f2 = p2 and p1 <> '*' and p2 <> '*' ) or ( p1 = '*' and p2 = '*' )

May be exists another issue?

BR, Marat.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question