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_Relationship_.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
