[ List Archives Home ] [ Thread index for 2007 ] [ Date index for 2007 ] [ Author index for 2007 ]


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Just a side note...
Order is important when you are using OR statements with your AND statements
,not when you're only using AND statements.

For example:

Construct for using an AND operator:
X AND Y AND Z AND K
is the same as
Y AND K AND Z AND X

Construct for using an OR operator:
X AND Y
OR
X AND Z
OR
..etc...

Frank
Adelphi University


>>> "Edith Fuller" <efuller at pps dot k12 dot or dot us> 5/16/2008 6:59 PM >>>

We*ve got a Boolean conundrum that defies explanation. In Create
Lists, does the order in which search elements are entered in Via have
an effect on the search outcome?

In two examples below where we*re looking for 12th grade students in
a particular high school who have at least one item checked out and owe
money, the search elements are the same, just given in different order:


PATRON Home Library equal to *3dg* AND PATRON Money Owed greater
than or equal to *0.10* AND PATRON Current Checkouts greater than
*0* AND PATRON Patron Type equal to *12*
Search returns 251 hits

PATRON Patron type equal to *12* AND PATRON Home Library starts
with *3dg* AND PATRON Current Checkouts greater than or equal to
*0* AND PATRON Money Owed greater than or equal to *0.10*
Search returns 230 hits.


Thanks for any clarity you can shed in this.


Edith Fuller
Librarian, Professional Library, Portland Public Schools

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies: INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac