On Tue, Jul 31, 2012 at 5:16 PM, Alain Tschanz wrote:
> Thank you very much for your quick response. Your SQL code solved my problem.
> May I ask a related SQL question:
> I would like to run a query that fetches all handles and files associated
> with a collection. Specifically, I need to know
Hello Alain,
the last number
30837199014132132506155472754588837323
corresponds to the the internal_id of the bitstream table.
In order to retrieve the handle of the item the bitstream belongs to,
along with the bitstream information you can use
SELECT distinct h.handle, b.* FROM bitstream b,
It should be also helpful to know the bitstream name in addition to item handle:
SELECT DISTINCT handle.handle_id, bitstream.name
FROM bitstream,bundle2bitstream,item2bundle,bundle,handle
WHERE handle.resource_id=item2bundle.item_id
AND item2bundle.bundle_id=bundle2bitstream.bundle_id
AND bundle2b
Hi Alain,
this should do the trick (I tested it only cursorily):
SELECT DISTINCT handle.handle_id
FROM bitstream,bundle2bitstream,item2bundle,bundle,handle
WHERE handle.resource_id=item2bundle.item_id
AND item2bundle.bundle_id=bundle2bitstream.bundle_id
AND bundle2bitstream.bitstream_id=bitstream
Hello,
How/where can I look up what handle corresponds to what directory/file in the
assetstore? For example, I tried to export a collection, but I received the
following error message:
The task exited unexpectedly or failed. For more information, please contact
the site administrator or check
5 matches
Mail list logo