Setfilter Prob.

upasanisandip
upasanisandip Member Posts: 405
Hi,
I am using SETFILTER in 1 codeunit.
Giving Error
The Filter 'R_OFF(O) is invalid.
It is not allowing me to enter brackets in Item code.

'R_OFF(O) is Item code.

Can anyone know abt this


Thanks

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    Try :
    Is it only 1 value? in this case use:
    SETRANGE("Item No.",'''R_OFF(O)');

    otherwise:
    SETFILTER("Item No.",'=%1','''R_OFF(O)');
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!