Here is a SQL query that inserts a status flag for all objects in an Object
Package. 

 

INSERT INTO StatusFlags (ObjectID, FlagID, OnOff, LoginID, EnteredDate,
TableID)

SELECT ObjectID, [the FlagID you want], 1, 'UserLogon', GetDate(), 108 

From StatusFlags WHERE ObjectID IN (select ID FROM PackageList 

INNER JOIN Packages ON PackageList.PackageID = Packages.PackageID 

WHERE Packages.Name = '[Your Package Name])

 

Dick

 

 


Richard Grant
Executive Director
3214 College Avenue 
Berkeley, CA 94705
 <mailto:[log in to unmask]> [log in to unmask]
510.428.1400 ext 4 
510.459.4556 mobile
 <https://www.instagram.com/diebenkornfoundation/> Instagram |
<https://twitter.com/diebenkorn_fnd> Twitter

 <http://www.diebenkorn.org/> 

 

 

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On
Behalf Of Clancy, Megan M - (meganclancy)
Sent: Monday, June 26, 2017 10:20 AM
To: [log in to unmask]
Subject: Adding status flags to an object selection

 

Hi all,

 

We are currently undergoing a big project that will be using status flags.
Currently we tend to use flags object by object, but this project will mean
flagging whole accession groups. Is there a way to apply a status flag to
the entire object selection? 

 

Thanks,

Megan

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.