Problem with setfilter

poppins

Hi everyone,

I want to set a filter on a record:
SETFILTER(Code,'<>%1',txtFilter);
I am using a function to generate the filter and sometimes it gives something like A|B
The problem is that the filter is not applied correctly.
I tried Message(MyRec.GETFILTERS); and I got the following : Code <> 'A|B'.
This is leading to false results (it looks like it is considering A|B as a code not a filter , not <>A & <>B).
Is there something wrong with my syntax?
How should it be?

THnaks in advance

postsaurav

What is the value you want to filter
1. A|B (If you are looking for Records A or
2. <>A AND <>B (If you are looking for Records other than A and

vijay_g

SETFILTER(Code,'<>%1',txtFilter); is not going to work as '%1' always looking for some value. the OR in this context will not work even if you will set write filter like SETFILTER(Code,txtFilter) where your txtfilter is '<>A|<>B'. it will not filter out. if you set txtfilter value to '<>A&<>B' could be work.
you can search forum, there has been so many post for Setfilter which may clear your doubt. one of them is forum.mibuso.com/discussion/46941/setfilter-blank-is-not-working-in-range-case

Wisa123

Instead of building huge filterStrings you should consider using MARK if applicable.