OR in Default Filter On Browse?

OR in Default Filter On Browse?

Postby armstrs01 » Tue Mar 08, 2016 1:12 am

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
 
Posts: 20
Joined: Wed Jul 15, 2015 12:30 am

Re: OR in Default Filter On Browse?

Postby admin » Thu Mar 17, 2016 11:33 am

armstrs01,

How many possible options could there be?

Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: OR in Default Filter On Browse?

Postby armstrs01 » Tue Mar 22, 2016 1:45 am

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.
armstrs01
 
Posts: 20
Joined: Wed Jul 15, 2015 12:30 am

Re: OR in Default Filter On Browse?

Postby admin » Thu Mar 31, 2016 7:33 am

Simon,

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

Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5

Re: OR in Default Filter On Browse?

Postby mobilemcclintic » Sat Apr 16, 2016 2:44 pm

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
 
Posts: 54
Joined: Fri Oct 23, 2015 8:04 am

Re: OR in Default Filter On Browse?

Postby admin » Thu May 05, 2016 3:27 pm

mobilemcclintic,

A Browse Form filters ANDS not ORS.

Steven
admin
Site Admin
 
Posts: 3406
Joined: Mon Jun 15, 2009 9:53 am
nuBuilder Version: 4.5


Return to Custom Code