Set Filter Problem

sanjeevdalelasanjeevdalela Member Posts: 45
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
Sanjeev Kumar Dalela
Technical Consultant
(Dataman Computer Systems P Ltd.)

Comments

  • kinekine Member Posts: 12,562
    try to use quotes around the value...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • sanjeevdalelasanjeevdalela Member Posts: 45
    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
    Sanjeev Kumar Dalela
    Technical Consultant
    (Dataman Computer Systems P Ltd.)
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • arindomarindom Member Posts: 52
    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");
  • rajpatelbcarajpatelbca Member Posts: 178
    I think if you will put range values eg. A0001..A0004 then its not working. if i am wrong then correct me.
    Experience Makes Man Perfect....
    Rajesh Patel
Sign In or Register to comment.