Hi
It is possible to do this. The field you need to add to your Query Assistant or Query Group is called 'Temporary Text', which is located under the Objects node of the available Hierarchies: Object Components>Current Location Transaction>Temporary Text. The field will appear in Query Assistant labelled as 'Temporary Text (Current Location). The field is also available underneath: Object Components>Location History>Temporary Text.
Best wishes
Jon
Jon Thristan | Project Consultant
[log in to unmask] | +44 20 7993 8402
GallerySystems | www.gallerysystems.com
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Margaret Bullock
Sent: 15 June 2012 03:11
To: [log in to unmask]
Subject: Remarks search in Location field
We are trying to do a search on the Remarks field in Current Location. Advanced Query allows for searches on everything else but not Remarks. I've tried adding it to the query fields in DB Config but it doesn't show up as available on the hierarchies. I can do Remarks searches in Temporary Location and Exhibition Location and all other Location fields just not Current. Has anyone else run into this problem and better yet, found a solution?
Thanks
Margaret Bullock
Margaret Bullock | TACOMA ART MUSEUM
Curator of Collections and Special Exhibitions
253.272.4258 x 3019
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of TMSUSERS automatic digest system
Sent: Thursday, June 14, 2012 2:00 PM
To: [log in to unmask]
Subject: TMSUSERS Digest - 13 Jun 2012 to 14 Jun 2012 (#2012-71)
There are 3 messages totaling 1760 lines in this issue.
Topics of the day:
1. searching location history (3)
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.
----------------------------------------------------------------------
Date: Thu, 14 Jun 2012 13:37:08 +0000
From: Kelly Rushing Carter <[log in to unmask]>
Subject: searching location history
Can anyone tell me if there is a way to search location history? I am trying to find every object that has ever been on display in a certain gallery. I can't seem to find the right field to do this in either Query Assistant or Advanced Query.
Thanks,
Kelly Rushing Carter
Registrar
Eiteljorg Museum of American Indians and Western Art
500 W. Washington St.
Indianapolis, IN 46204
Direct: 317-275-1359
Fax: 317-275-1459
[log in to unmask]
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.
------------------------------
Date: Thu, 14 Jun 2012 09:14:46 -0500
From: Christine Droll <[log in to unmask]>
Subject: Re: searching location history
Kelly, you can use the Locations search in the Query Assistant:
[cid:image001.png@01CD4A0E.246DB6E0]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kelly Rushing Carter
Sent: Thursday, June 14, 2012 8:37 AM
To: [log in to unmask]
Subject: searching location history
Can anyone tell me if there is a way to search location history? I am trying to find every object that has ever been on display in a certain gallery. I can't seem to find the right field to do this in either Query Assistant or Advanced Query.
Thanks,
Kelly Rushing Carter
Registrar
Eiteljorg Museum of American Indians and Western Art
500 W. Washington St.
Indianapolis, IN 46204
Direct: 317-275-1359
Fax: 317-275-1459
[log in to unmask]<mailto:[log in to unmask]>
To unsubscribe, send an email to [log in to unmask]<mailto:[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.
------------------------------
Date: Thu, 14 Jun 2012 16:27:42 +0000
From: "Morgan, Amber" <[log in to unmask]>
Subject: Re: searching location history
Hi Kelly,
If you can't find the right field, you might have to add it to your Query Groups in Advanced Query. It's in DBConfig, under Manage -- Query Groups. You can add different query groups to Query Assistant also, but I am drawing a complete blank on how to do that. Check the TMS manuals or the GS website for configuring Query Groups - it's actually very easy to do, but it will be easier to follow along with the existing instructions than it would be for me to try to explain it over email.
Once you figure out how to configure Query Groups (or if you already know how), you have to find the "location history" stuff in the "Available Hierarchies", which is under "Objects" and then "Object Components." You basically just drag and drop the fields you need into an existing Query Group, or you can make a new Query Group.
I can guarantee that there are people out there who would be far better at explaining this, but hopefully I was able to give you enough info to start looking in the right place. :)
Best regards,
Amber
the warhol:
Amber E. Morgan
Associate Registrar
117 Sandusky Street
Pittsburgh, PA 15212
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org<http://www.warhol.org/>
The Andy Warhol Museum
One of the four Carnegie Museums of Pittsburgh Email newsletter http://members.carnegiemuseums.org/email
Membership http://members.carnegiemuseums.org/SupportCMP
warhol: facebook<http://www.facebook.com/thewarholmuseum> | warhol: twitter<http://www.twitter.com/thewarholmuseum>
________________________________
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kelly Rushing Carter
Sent: Thursday, June 14, 2012 9:37 AM
To: [log in to unmask]
Subject: searching location history
Can anyone tell me if there is a way to search location history? I am trying to find every object that has ever been on display in a certain gallery. I can't seem to find the right field to do this in either Query Assistant or Advanced Query.
Thanks,
Kelly Rushing Carter
Registrar
Eiteljorg Museum of American Indians and Western Art
500 W. Washington St.
Indianapolis, IN 46204
Direct: 317-275-1359
Fax: 317-275-1459
[log in to unmask]
To unsubscribe, send an email to [log in to unmask]<mailto:[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.
The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.
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.
------------------------------
End of TMSUSERS Digest - 13 Jun 2012 to 14 Jun 2012 (#2012-71)
**************************************************************
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.
|
