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, 9 Apr 2019 13:37:07 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (1 lines) 
Good catch Christina!

Try this:

update packages
set packages.locked = 1
where packages.packageid in (X,Y,Z) and packages.tableid = 108

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

- Rob

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christina Gibbs
Sent: Friday, April 5, 2019 5:01 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: Re: batch lock object packages?

And throw tableID = 108 (objects). Unlikely, but if you are using packages in other modules, it is possible to have a package in more than one mod w/the same ID.

Christina

Christina Gibbs
Collections Database Manager

Detroit Institute of Arts
5200 Woodward Avenue│Detroit, MI

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Morgan, Rob
Sent: Tuesday, April 02, 2019 4:55 PM
To: [log in to unmask]
Subject: Re: batch lock object packages?

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.

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