All -

Gallery Systems helped me write a SQL script to add status flags to items in an object package, like this (Im not sure I understand the second line of this script, but you may need to customize for your FlagID here as well):

Insert into StatusFlags (ObjectID, FlagID, OnOff, LoginID, EnteredDate)

Select ID, 1, 1, 'GSInsert', GetDate() 

from PackageList where PackageID = [enter your packageID here]

and FlagID <>[enter the new FlagID here]


Kim Koons



On Mon, Jun 26, 2017 at 12:19 PM, Clancy, Megan M - (meganclancy) <[log in to unmask]> wrote:

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] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed




--
Kimberly Koons, Presidential Libraries Museum Collections Officer
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
202-357-5082
301-837-0873
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.