Sunita, I am placing your question back on the dspace-tech mailing list since it relates to a question that originated there.
The query you reference was compatible with the DSpace 4x shema. This SQL will work with a DSpace 5x schema. select h.handle, regexp_replace(t.text_value,E'[\r\n\t ]+',' ','g') as title from item i2 inner join metadatavalue t on t.resource_id = i2.item_id and t.resource_type_id = 2 inner join metadatafieldregistry mfr on t.metadata_field_id=mfr.metadata_field_id and mfr.element='title' inner join handle h on h.resource_id = i2.item_id and h.resource_type_id = 2 where not exists (select 1 from item2bundle i2b inner join bundle b on i2b.bundle_id = b.bundle_id where i2.item_id = i2b.item_id) On Sat, Feb 6, 2016 at 12:01 AM, Sunita Barve <sunitaba...@gmail.com> wrote: > I found following thread and tried to run on my dspace but it didnot > retrieve missing bitstreams from my dspace. > > I am looking for a command which will help me to get items available in my > dspace where bitstream is missing. > > > https://groups.google.com/forum/#!searchin/dspace-tech/items$20without$20bitstreams/dspace-tech/wj3vl_iSK2Y/tKrZUs_6BgAJ > > select h.handle, regexp_replace(t.text_value,E'[\r\n\t ]+',' ','g') as title > from item i2 inner join metadatavalue t on t.item_id = i2.item_id inner join > metadatafieldregistry mfr on t.metadata_field_id=mfr.metadata_field_id and > mfr.element='title' inner join handle h on h.resource_id = i2.item_id and > h.resource_type_id = 2 where not exists (select 1 from item2bundle i2b inner > join bundle b on i2b.bundle_id = b.bundle_id where i2.item_id = i2b.item_id) > > When i run about command it says > > ERROR: column t.item_id does not exist > LINE 1: ... title from item i2 inner join metadatavalue t on t.item_id ... > > am i missing anything. can u let me know what is correct command to get > list of items from dspace where bitstream is missing. > > thanks, > > > -- 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.
