/scripts/ahub.form.attachments.js
0

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

May 10, 2017 at 03:30 PM

20

avatar image

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..

pmkmf.png (55.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content