TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: broken media links
From:
"Smith, Jeffrey" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 23 May 2016 20:38:25 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (1125 bytes) , text/html (6 kB) 
Ella,

Try this one:

use yourdatasource
select mr.renditionnumber
from mediamaster mm inner join mediarenditions mr on mm.mediamasterid = mr.mediamasterid
where mm.mediamasterid not in
 (select mediamasterid
from mediaxrefs)

And yes, we have some orphaned media records laying around!

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Ella Rothgangel
Sent: Monday, May 23, 2016 4:28 PM
To: [log in to unmask]
Subject: broken media links

Has anyone figured out a view, script, report, or query to see only media records where the link has been broken?


Ella Rothgangel
Acting Head of Registration
Saint Louis Art Museum
314.655.5408

To unsubscribe, send an email to [log in to unmask]<mailto:[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.

ATOM RSS1 RSS2