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.