To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:Hi all,
We recently migrated to ResourceSpace for our DAMS which has a TMS plugin in order to populate metadata using ObjectID. However, it can only function on a singular table or a data view. The fields I want populated upon upload live on two tables – Objects and ObjRights. However, I also want the artist as well. I’m hoping to get around having to include the constituent tables by creating a new view off vgsrpObjTombstoneD_RO and vgsrpObjRightsS_RO, is this possible?
Regardless, I don’t have much experience with creating new views database side I was wondering if anyone could help me out with the syntax for adding the following fields to a new database view?
Artist
Title
Date
Medium
Dimensions
Object Number
Department
Credit Line
Copyright
Restrictions
Credit Line Repro
Thanks!
Jeremy Munro
Collections Information Coordinator
Crystal Bridges Museum of American Art
479.418.5710 (direct)
479.418.5700 (main)
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.