Using wildchars with setfilter

ireneg
ireneg Member Posts: 30
Hi there

I want to use a '*' wildchar with a setfilter command, I've tried using it like this:
rMainShed.SETFILTER(rMainShed."Shed No.",'%1*',Customer."No.");

I'm not getting the correct result. Am I doing something wrong?

Thanks

Irene
Irene Grassow

Answers

  • ara3n
    ara3n Member Posts: 9,258
    This should work.


    rMainShed.SETFILTER(rMainShed."Shed No.",'%1',Customer."No."+'*');
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ireneg
    ireneg Member Posts: 30
    It's working, thank you!
    Irene Grassow
  • garak
    garak Member Posts: 3,263
    also possible:
    rMainShed.SETFILTER("Shed No.",Customer."No."+'*'); //without the %1
    

    Regards.

    So please write [SOLVED] infront of the subject in your first post. Thanks
    Do you make it right, it works too!