Thank you Silvia and David for your help.
Silvia, I need to turn-off all Public Access from the media module in some records.
Thanks and regards!
Adrián Pérez Camarena
Sistemas
Museo Nacional de Arte
Tacuba 8, 3er piso Centro Histórico
Cuauhtémoc, 06010
México D. F.
Tel +52 (55) 86475436
[https://lh5.googleusercontent.com/fKCbxCJHBbCy3nax07-1DlSG4bK5Subd_OYHnXEHbdB1-0Gu8KmPgnT-yHfO34tmCi_12jJUMd8wXzgTDgf2OpdPOFzQNGg-TUGaOk28eUB_DIKp3bRoFs2XyVCjpI9wM_rumKrK]
* La información de este correo así como la contenida en los documentos que se adjuntan, puede ser objeto de solicitudes de acceso a la información
* Considera el medio ambiente antes de imprimir
________________________________
De: The Museum System (TMS) Users <[log in to unmask]> en nombre de Welsh, Sylvia C. <[log in to unmask]>
Enviado: jueves, 7 de diciembre de 2017 08:09 a. m.
Para: [log in to unmask]
Asunto: Re: Tweaking a quey
Hi Adrian,
I have some SQL scripts saved which either turn-on Public Access for all Objects/Sites/Media (depending on your needs) and one that turns-off all Public Access. I am happy to share them with you if they might be of use - please let me know and I will send them via email.
Sincerely,
Sylvia,
_____________________________
Sylvia Welsh, MS LIS, CSI, LEED AP BD+C
Harvard Property Information Resource Center
1350 Massachusetts Avenue, 547
Cambridge, MA 02138
T 617-496-8275 F 617-495-0559
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Parsell, David
Sent: Thursday, December 07, 2017 7:39 AM
To: [log in to unmask]
Subject: Re: Tweaking a quey
The mediaXrefs table provides the link between Objects and MediaMaster tables.
Objects.objectID=mediaXrefs.ID
mediaXrefs.mediamasterID=mediamaster.mediamasterID
I suggest asking GS technical support these technical questions. Brian and Dimytri respond quickly and are very technically adept.
David Parsell
Yale Center for British Art
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Adrián Pérez Camarena
Sent: Wednesday, December 6, 2017 4:42 PM
To: [log in to unmask]
Subject: Tweaking a quey
Hi dear friends,
I would like to know how can I update the check "Public Access" from the Objects module and from the Media tab in the same module executing a query from the data base and which tables are involved in this query and what is the field that makes the link between Objects table and MediaMaster table. I can not find a field that makes the link between this two tables, I think there must be a third table.
I have to update about 1000 records and I would like to do it with a query.
Has anyone else come across this a managed to resolve it?
Thank you.
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.
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.
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.
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.
|
