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
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 meta
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 wrote:
> Hi Alan,
>
> Discovery
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
Hi Alan, that's close, but not quite what I was suggesting: the ||| will
not be stored in the database, that's added in when indexing the values to
Solr, so I think a SQL query like:
select item_id from metadatavalue where metadata_field_id=86 and
(text_value='' OR text_value IS NULL);
Will be cl
Bingo, I found the item, and then got its handle using the item_id:
dspace=# SELECT * FROM item, handle WHERE handle.resource_id = item.item_id
AND item.item_id = '66841';
The item did indeed have empty contents for that field. I deleted it from
the "Edit this item" function in the web interface
6 matches
Mail list logo
