nuBuilder Forum

Is there a way to apply an AND or OR filter to the Default Filter for Browse Screen of a button object?

For example, I want to look for ever occurrence of a BIN number in a column if it begins with 08. OR 12.

Is it possible to filter on 08. OR 12.?

Thanks.

armstrs01,

How many possible options could there be?

Steven

Steven,

I just need to be able to do a filter in say, A OR B - or X AND Y...

Nothing too complicated. I don't need to do (X AND Y) OR (A AND B)...etc.

Many thanks,
Simon.

Simon,

No there isn't. You'll need to create a column where both = x and then search for x.

Steven

Maybe I'm not reading the request correctly, but if this is a default filter set at the button level (Like it wouldn't change), wouldn't it be easy enough to create a clone of the form and change the SQL it contains, and then have it open up the original form to edit?

Normal button: Form 1 (show all records)
08 OR 12 button: Form 2, select blah blah where A like '08%' or A like '12%' , Edit using Form 1
08 AND 12 button: Form 3, select blah blah where A like '08%' and B like '12%' , Edit using Form 1

Edited to remove 08 or 12 with 08 and 12 at once (redundant)

mobilemcclintic,

A Browse Form filters ANDS not ORS.

Steven