Hi helix We just run in a problem because we now have multiple thumbnail images (one low resolution, one that is high resolution)
Which means that the sequence is now important to load the correct bitstream. Is there a way to get the sequence for the filenames via SQL? How do we need to rewrite the SQL to get the filename and correct sequence id? Thanks Rodrigo -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of helix84 Sent: Thursday, October 25, 2012 3:50 PM To: Calloni, Rodrigo Cc: [email protected] Subject: Re: [Dspace-tech] SQL to export the thumbnail filename On Thu, Oct 25, 2012 at 9:37 PM, Calloni, Rodrigo <[email protected]> wrote: > This said, we would like to know if there is a SQL query that we could > use to get the thumbnail filename of all thumbnails (in this example I > need to get: > Shaping_the_Future_of_the_Asia_Latin_America_and_the_Caribbean_Relatio > nship_.pdf.jpg?sequence=3) You can safely drop "?sequence=3", it works the same without it. I can't imagine why you would need _only_ thumbnail names, I usually need them with handle or item_id. SELECT bitstream.name FROM bitstream,bundle2bitstream,bundle WHERE bundle.name = 'THUMBNAIL' AND bundle2bitstream.bitstream_id = bitstream.bitstream_id AND bundle2bitstream.bundle_id = bundle.bundle_id; Regards, ~~helix84 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
