Set Filter Problem

sanjeevdalela

I am Using Set filter Code Field
if field data include & or / etc. Character then Filter Fails So
Please Suggest me How to Filter the Data.

Thanks

kine

try to use quotes around the value...

sanjeevdalela

I try with ' add but not Sucess


Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head","Product Group Master"."Product Group Head");
Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name","Product Group Master"."Product Group Name");

Data in Product Group Name Give Another Solution

kine

If you are using code, than correct form of using SETFILTER is:

Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head",'%1',"Product Group Master"."Product Group Head");
Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name",'%1',"Product Group Master"."Product Group Name");

In this case NAV will do all what you need...

arindom

U can write u 'r code as in bellow then & and \ will work .

Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Head",'%1',"Product Group Master"."Product Group Head");
Rec_IncentiveMasterLineG.SETFILTER(Rec_IncentiveMasterLineG."Product Group Name",'%1',"Product Group Master"."Product Group Name");

rajpatelbca

I think if you will put range values eg. A0001..A0004 then its not working. if i am wrong then correct me.