SETFILTER by CustomerName start FROM character TO character

vandangvandang Member Posts: 101
edited 2015-03-25 in NAV Three Tier
Dear All,

I'd like to ask is there any way to search the Customer record base on the Customer name.
Ex: All customer name start FROM $ (all characters) TO all customer name start from S
then All customer name start FROM T TO all customer name start from Z

I put the code:
Cust.RESET;
CUST.SETFILTER(Name,'>=%1&<=%2','T*','Z*');

OR
Cust.RESET;
CUST.SETFILTER(Name,'%1..%2','T*','Z*');

Also not working, appreciate any advice with thanks!

EDIT:

Actually CUST.SETFILTER(Name,'%1..%2','T*','Z*');
can find the list but its missing
IF i put there Z* only the result will list all start from Z like : Z 1, Z a, Za,Zb...

but CUST.SETFILTER(Name,'%1..%2','T*','Z*'); just can find Z 1, Z a (with the space only) not include Za,Zb...

Answers

  • vandangvandang Member Posts: 101
    I put there:

    CUST.SETFILTER(Name,'%1|%1..%2|%2','T*','Z*');

    So far I can get the expected result.
    If you know there is any other ways for this please kindly share. Thanks!
Sign In or Register to comment.