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?
From: ivan.masar@... [mailto:ivan.masar@...] On Behalf Of helix84
Sent: Thursday, October 25, 2012 3:50 PM
To: Calloni, Rodrigo
Subject: Re: [Dspace-tech] SQL to export the thumbnail filename
On Thu, Oct 25, 2012 at 9:37 PM, Calloni, Rodrigo <RCALLONI@...> 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:
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.
WHERE bundle.name = 'THUMBNAIL'
AND bundle2bitstream.bitstream_id = bitstream.bitstream_id AND bundle2bitstream.bundle_id = bundle.bundle_id;