Problem on filtering filed No.

nromain
nromain Member Posts: 57
edited 2008-06-30 in NAV/Navision Classic Client
Hello everybody,

Maybe it's monday and i'm not correctly awaken but i have an issue that looks simple...

I try to filter chart of accounts on a filtering field of a setup table. The filtering field can talk values like 111000..222000 (for instance).

My chart of accounts must contain all accounts different from accounts between 111000 and 222000..

On the Open form of the chart of accounts, i have put this code :

SETFILTER("No.",'<>%1',"G/L Account Filter");

And it doesn't work and i don't know why..

Thanks for your help !!

Comments

  • bbrown
    bbrown Member Posts: 3,268
    SETFILTER("No.",'<%1|>%2',GETRANGEMIN("G/L AccountFilter"),
    GETRANGEMAX("G/L Account Filter"));
    There are no bugs - only undocumented features.
  • nromain
    nromain Member Posts: 57
    Thank you for your reply but my problem is that the filtering field can be a range or a value or twice, etc...

    111000..222000
    111000&111001
    111000&222000..333000

    There is not always a range.
  • Albertvh
    Albertvh Member Posts: 516
    Where do you get the Setup table record?

    Maybe in the OnOpen

    SomeSetup.GET;


    Hope this helps


    Albert
  • garak
    garak Member Posts: 3,263
    setfilter("No.","G/L Account Filter"); helps

    because your "G/L Account Filter" includes wildcards and wildcards in Parameter 3 of setfilter does'nt work

    See also this post http://www.mibuso.com/forum/viewtopic.p ... =setfilter
    Do you make it right, it works too!

Categories