TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: batch lock object packages?
From:
"Morgan, Rob" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 2 Apr 2019 20:55:04 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (1 lines) 
Hi Liz,

You can batch lock object packages via the backend, via SQL.  I'd recommend trying on a test, first, before you apply to production.

update objectpackages
set objectpackages.locked = 1
where objectpackages.objectpackageid in (X,Y,Z)

X,Y,Z being the different objectpackageids for the packages you want to lock.

Good Luck!

- Rob Morgan
  IT Specialist in Data Management and Systems Administration
  Office of the Chief Information Officer
  Smithsonian Institution

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Liz Byrne
Sent: Tuesday, April 2, 2019 4:29 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: batch lock object packages?

Hello - Is it possible to batch lock a bunch of object packages, rather than doing it one by one? Thanks!

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.

ATOM RSS1 RSS2