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 |
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] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.