Problem on filtering filed No.

nromain

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 !!

bbrown

SETFILTER("No.",'<%1|>%2',GETRANGEMIN("G/L AccountFilter"),
GETRANGEMAX("G/L Account Filter"));

nromain

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

Where do you get the Setup table record?

Maybe in the OnOpen

SomeSetup.GET;


Hope this helps


Albert

garak

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