I have a good old-fashioned list question.
I want to find bibs which have attached items with location mbe and tot checkouts = 0 and also have attached items with location mbe and tot checkouts 1+. I tried grouping these to force the system to give me bibs which had attached items matching both tot checkout criteria.
(ITEM LOCATION starts with "mbe " AND ITEM TOT CHKOUT greater than or equal to "1"
(ITEM LOCATION starts with "mbe" AND ITEM TOT CHKOUT less than "1"
But no the system seems to be ORing them, giving me many bibs which have only 1 item from the location specified, which may randomly have 0 or 1+ checkouts .
Does anyone have any great advice? Is this a bug?
Thanks so much,