Hi Jen,
THANK YOU SO MUCH!! The second option worked like a charm!! I can’t wait until inventory is OVER!
Jessica
Jessica Wilks
TACOMA ART MUSEUM
Associate Director of Curatorial and Head Registrar
253-272-4258 x3021
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Jennifer W. Smith
Sent: Friday, May 04, 2018 8:02 AM
To: [log in to unmask]
Subject: Re: Query conundrum
Hi, Jessica! Greeting from the Midwest!
You could try changing your field group to Current Location. This should allow you to focus the “not equal to” relation on only those items without the current Location Purpose you’re looking for. This will only work you have not recorded
moves subsequent to those containing your purpose “2017 Inventory,” tho.
Alternatively, using your AQ and the “equal to” query you show below, you can assemble your group of objects that have (at any time) been part of the inventory in a temporary object package. Then, change your main view to find all objects
and while the temporary object package is highlighted, use the “Remove list from current selection” option from the Action menu in your Package Explorer window to focus on only those not yet inspected.
Hope these two ideas help!
All best,
Jen
Jennifer W. Smith
JWSC LLC - Art Catalogues, Technology, and Research
212 South Marion Street, Suite 10 Oak Park, IL 60302
(708) 445-9101
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Jessica Wilks
Sent: Thursday, May 3, 2018 7:56 PM
To: [log in to unmask]
Subject: Query conundrum
Hi All,
I need help…
We are just wrapping up a full touch inventory of our collection and we are having a hard time querying the database for records that do not have a location purpose of “2017 Inventory” under
the Location query option in Advanced Query. The picture below show how we are query what has been inventoried. When I change the relation to “Not Equal to” I am getting objects that have been inventoried. Does anyone know how I would find out what has
not been inventoried?
Thanks so much in advance!!
All best,
Jessica
Jessica Wilks
Associate Director of Curatorial and Head Registrar
TACOMA ART MUSEUM
1701 Pacific Avenue, Tacoma, WA 98402
T: 253-272-4258 x3021
Office hours: Tuesday – Friday, 8 am – 6 pm
Connecting people through art.
To unsubscribe, send an email to
[log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to
[log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.