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.
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
OR in Default Filter On Browse?
-
- Posts: 20
- Joined: Tue Jul 14, 2015 5:00 pm
Re: OR in Default Filter On Browse?
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.
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.
-
- Site Admin
- Posts: 2781
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 1 time
Re: OR in Default Filter On Browse?
Simon,
No there isn't. You'll need to create a column where both = x and then search for x.
Steven
No there isn't. You'll need to create a column where both = x and then search for x.
Steven
-
- Posts: 54
- Joined: Fri Oct 23, 2015 12:34 am
Re: OR in Default Filter On Browse?
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)
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)