I’ve discovered that you can unlock advanced queries in
TMS but there’s some (surely unintentional) quirkiness to it -- if
you pull up the saved query, click on the ‘Sort’ tab and then back
on the ‘Search For’ tab, you’ll then be able to uncheck the ‘Locked’
box. We’re in TMS 9.35.3530.
Jeri
Jeri Moxley
Manager, Collection and Exhibition Technologies
Collection Management and Exhibition Registration
The Museum of Modern Art
11 West 53 Street, New York, NY 10019-5497
Tel. (212) 708-9599 Fax. (212) 333-1102
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of Parsell,
David
Sent: Monday, December 07, 2009 12:28 PM
To: [log in to unmask]
Subject: Re: modifying/deleting locked advanced query
The quickest way is to use SQL
or whatever db you are using to open the advanced queries table, find the
appropriate query and change the “locked” field from 1 to 0.
Once you save the table and
restart TMS, the query will be unlocked.
Also, if you are TMS sys.admin
you should be able to set your security in TMS so that you can unlock locked
tables (I’m making a big assumption here, I always use the SQL route to
make things global that I need to see.).
Your technical sys.admin can do
these things for you. Hope it helps, David
David Parsell
Systems Manager
Yale Center for British Art
1080 Chapel Street
PO Box 208280
New Haven, CT 06520-8280
203 432-9603
From: The Museum System (TMS)
Users [mailto:[log in to unmask]] On Behalf Of Elizabeth
Chambers
Sent: Monday, December 07, 2009 12:17 PM
To: [log in to unmask]
Subject: modifying/deleting locked advanced query
Good afternoon,
Does anyone know how to modify or delete a saved, locked
advanced query? I created an advanced query, made it public but locked so
no one could manipulate it. I now want to modify it myself but it
won’t let me. I can’t figure out how to delete it either.
I have searched the online manual but could not find anything.
Thanks for your help!
Elizabeth
Elizabeth Chambers
Collections Manager
George Washington's Mount Vernon Estate & Gardens
P.O. Box 110
Mount Vernon, Virginia 22121
703-799-6807; Fax: 703-799-8698
P Please consider the environment before printing this email