Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2015-01-07 Thread helix84
06, 2015 12:42 PM > To: Brown, Jacob > Cc: DSpace-tech@lists.sourceforge.net > Subject: Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream > > > > OK, Guys, just call me dense, but I can't make sense of Jacob's query - > where it says, bundle.name=&

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2015-01-06 Thread Brown, Jacob
e...@gmail.com<mailto:marke...@gmail.com>] Sent: Wednesday, December 10, 2014 11:12 AM To: DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net> Subject: [Dspace-tech] Query to get ID of thumbnail of primary bitstream Folks - I am in need of a way to query postgres in Dspace to g

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2015-01-06 Thread Mark Ehle
dle.bundle_id AND bundle.name='THUMBNAIL' >> >> AND bundle.bundle_id=bundle2bitstream.bundle_id AND >> bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name >> IN (SELECT name from nameHolder) >> >> ) SELECT id FROM namedBitstream; &

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2014-12-11 Thread Mark Ehle
OM itemHolder) AND > item2bundle.bundle_id=bundle.bundle_id AND bundle.name='THUMBNAIL' > > AND bundle.bundle_id=bundle2bitstream.bundle_id AND > bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.name > IN (SELECT name from nameHolder) > > ) SELECT id FROM named

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2014-12-10 Thread Brown, Jacob
.bitstream_id=bitstream.bitstream_id AND bitstream.name IN (SELECT name from nameHolder) ) SELECT id FROM namedBitstream; Jacob From: Mark Ehle [mailto:marke...@gmail.com] Sent: Wednesday, December 10, 2014 11:12 AM To: DSpace-tech@lists.sourceforge.net Subject: [Dspace-tech] Query to get ID of th

Re: [Dspace-tech] Query to get ID of thumbnail of primary bitstream

2014-12-10 Thread Terry Brady
The following query might help. I use this to generate thumbnail links in a PHP report tool. This assumes you have already queried an item from table item i. You would need additional logic to extract the primary bitstream. select array_to_string(array_agg(text('{$handleContext}/bitstream/id/'

[Dspace-tech] Query to get ID of thumbnail of primary bitstream

2014-12-10 Thread Mark Ehle
Folks - I am in need of a way to query postgres in Dspace to give me the ID of the primary bitstream's thumbnail ID. I am able to get the primary bitstream ID from the handle (thanks to helix84 , http://dspa