I do this in jruby using the dspace-jruby gem I developed
see on GitHub https://github.com/akinom/dspace-jruby
<https://github.com/akinom/dspace-jruby>
#find items with given metadata value
items = DSpace.findByMetadataValue('pu.workflow.state', 'reviewed',
DConstants::ITEM)
# print their ids and handles
items.each do |i|
puts [i.getID, i.getHandle].join "\t”
end
#find bitstreams with metadata dc.type = other
bits = DSpace.findByMetadataValue('dc.type', 'other', DConstants::BITSTREAM)
# then go look at file name with an extension that you are interested in
bits.each do |b|
ext = b.getName.split('.')[-1]
if (["pdf", "txt", "jpeg"].include?(ext)) then
puts [ext, b.getID, b.getName, b.getParentObject.getID,
b.getParentObject.getHandle].join "\t"
end
end
# bitstreams for items with dc.contributor = ‘University of Stuff’
items = DSpace.findByMetadataValue('dc.contributor', 'University of Stuff',
DConstants::ITEM)
items.each do |i|
bits = i.getBundles('ORIGINAL')[0].getBitstreams
# similar to the above example
end
Let me know if you need help with using this
Monika
________________
Monika Mevenkamp
mo.me...@gmail.com
http://mo-meven.tumblr.com/
http://mcmprogramming.com/mo.meven/
> On Apr 5, 2017, at 10:35 AM, Brendow Adriel <aesystem...@gmail.com> wrote:
>
> For example:
>
> How to select all bitstream from database
>
> where dc.contributor = ''University";
>
>
> Select all files with final (.pdf, txt, jpg, mp3)
>
> where dc.type= 'other'.
>
> or
>
> Select all files with final (.pdf, txt, jpeg, mp3)
>
> where dc.contributor = 'University of Technology'.
>
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com
> <mailto:dspace-tech+unsubscr...@googlegroups.com>.
> To post to this group, send email to dspace-tech@googlegroups.com
> <mailto:dspace-tech@googlegroups.com>.
> Visit this group at https://groups.google.com/group/dspace-tech
> <https://groups.google.com/group/dspace-tech>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google Groups
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.
