Hi Mark, Jacob,
you're both correct. bundle.name was used in DSpace up to version 4.
DSpace 5 and later moves metadata of DSpace objects to the
metadatavalue table. The code in ItemDAOPostgres is clearly wrong, but
has been missed, probably because it rarely triggers. I filed a bug
report [1]
Sorry, I should have clarified that this was for a DSpace 4.1 setup…
I don’t know anything about the database tables for 5.x, but I just looked at:
https://github.com/DSpace/DSpace/blob/dspace-5.0-rc2/dspace-api/src/main/java/org/dspace/content/dao/ItemDAOPostgres.java
which still references a
OK, Guys, just call me dense, but I can't make sense of Jacob's query -
where it says, bundle.name='THUMBNAIL' - the bundle table does not have a
name field. What am I missing?
(This is on a DSpace 5.0-rc2 box)
Thanks -
Mark
On Thu, Dec 11, 2014 at 7:08 AM, Mark Ehle marke...@gmail.com wrote:
Thanks, guys! That gives me something to chew on. What I need the query for
is to generate a media rss feed from Dspace.
On Wed, Dec 10, 2014 at 5:16 PM, Brown, Jacob j.h.br...@tcu.edu wrote:
Hi Mark,
Not sure if what you are using the query for, but if you are using it
inside a Java
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://dspace.2283337.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodesuser=211466,
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/'
Hi Mark,
Not sure if what you are using the query for, but if you are using it inside a
Java application, DSpace provides a
[service](https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/content/service/ItemService.java)
to get the primary bitstream’s thumbnail for
7 matches
Mail list logo