So I found the metadata_field_id for this metadata item using a known valid value:
dspace=# select * from metadatavalue where text_value='DRYLAND CEREALS'; ... and then I tried to find text values containing several variations of "|||", like '\|\|\|', '%|%', '%\|%' etc... dspace=# select item_id from metadatavalue where metadata_field_id=86 and text_value='|||'; But I am not getting any hits. I also figured that, since we figured CSV export by nature wouldn't expose this anomaly, that I could simple export and re-import, but DSpace said no changes were detected upon re-import. Hmmm. Anyone know how I could query Solr directly for this information? Alan On Fri, Jul 31, 2015 at 9:35 AM Alan Orth <alan.o...@gmail.com> wrote: > Thanks for the interesting suggesting, Kim! This is happening in DSpace > 4.3. I will try to poke around in the database, as you're probably right > that this anomaly probably wouldn't make it through a CSV export... > > Alan > > On Thu, Jul 30, 2015 at 1:44 PM Kim Shepherd <kim.sheph...@gmail.com> > wrote: > >> Hi Alan, >> >> Discovery filters use ||| as a separator between lowercase value and a >> display/stored value, eg. something|||SomeThing >> I'm sort of surprised it displays in the sidebar, because acting as the >> separator, it should be pulled out, but I think the first thing I'd look >> for is empty or null metadata values in your database (probably easier than >> CSV because of how metadata export works), for the field in question. >> >> What version is this happening in? >> >> M: k...@shepherd.nz >> T: @kimshepherd >> P: +6421883635 >> >> 0CCB D957 0C35 F5C1 497E CDCF FC4B ABA3 2A1A FAEC >> https://keybase.io/kshepherd >> >> On 30 July 2015 at 20:45, Alan Orth <alan.o...@gmail.com> wrote: >> >>> Hi, >>> >>> I've got an strange metadata value shown in one of our XMLUI Discovery >>> sidebar facets, and I'm not sure how to find the offending item to fix it. >>> >>> The value is displaying as "|||", and I've narrowed down the collection >>> the item belongs to by navigating through my communities and looking at the >>> facet in question. I've exported the metadata as CSV and attempted to find >>> the item using LibreOffice and OpenRefine but nothing strange sticks out... >>> >>> Does anyone have any suggestions? >>> >>> Thanks, >>> >>> Alan >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> DSpace-tech mailing list >>> DSpace-tech@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >>> List Etiquette: >>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette >>> >>
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette