Re: [IUG] Create list quandary

["Jackson, Richard" <rjackson at huntington dot org>]

Donna,

I would guess this has nothing to do with the order of your search
statements.  Is it possible between the time you ran your first search
and the time you ran your second that 7 more orders were given current
received dates?

Instead of using "greater than or equal to", try using the "between"
operator with your dates to specify both a start and end date.  For
example:

     ORDER  Recv Date  between  07/01/2007  &  06/30/2008

Richard V. Jackson
Head of Copy Cataloging / Database Manager
Huntington Library, Art Collections, and Botanical Gardens
1151 Oxford Road, San Marino, CA 91108
rjackson at huntington dot org / 626-405-2100 x2384

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Donna Campbell
Sent: Tuesday, July 01, 2008 12:55 PM
To: IUG INNOPAC List
Subject: [IUG] Create list quandary

Hi there,

I seem to recall that someone asked a similar question not too long ago
but I can find neither it nor any of the responses. Why does the order
of search parameters affect the number of hits for a query? See example
below:

Query #1
Store record type: order
Type = ORDER Field = Order Type Condition = equal to Value A = f
AND
Type = ORDER Field = Recv Date Condition = greater than or equal to
Value A = 07-01-2007
Number of hits: 1257

Query #2
Store record type: order
Type = ORDER Field = Recv Date Condition = greater than or equal to
Value A = 07-01-2007
AND
Type = ORDER Field = Order Type Condition = equal to Value A = F
Number of hits: 1264

Donna R. Campbell
Acquisitions and Cataloging Librarian
(215) 935-3872
(215) 887-3412 (fax)
Mailing Address:
Westminster Theological Seminary Library
P.O. Box 27009
Philadelphia, PA 19118
USA
Shipping Address:
Westminster Theological Seminary Library
2960 W. Church Rd. 
Glenside, PA 19038
USA
 


--
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