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.
|