cancel
Showing results for 
Search instead for 
Did you mean: 

Syntax error in Derived Table while passing @prompts in the Where Clause as optional

amitkumar_dey
Explorer
0 Kudos

Syntax error in Derived Table while passing @prompts in the Where Clause . Can't We mention Optional in @Prompt Syntex in the where clause?

My need is to pass Two below Parameter as optional in the Where Clause.

WHERE (("_BIC_MYBILLTYP" IN (@Prompt(Bill Type))) AND (("_BIC_MYSOLDTO" IN (@Prompt(SoldToParty))) .

I am using BO 4.1 IDT . I tried with One parameter but throwing below error. Kindly Help..

Accepted Solutions (0)

Answers (0)