Skip to content

Instantly share code, notes, and snippets.

@alanorth

alanorth/dspace-sql

Created August 2, 2015 13:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alanorth/5724d00438e740fc4a62 to your computer and use it in GitHub Desktop.
Save alanorth/5724d00438e740fc4a62 to your computer and use it in GitHub Desktop.
Download ZIP
Finding the item causing the "|||" in the CGIAR Research Programs XMLUI facet.
Raw
dspace-sql
dspace=# select item_id from metadatavalue where metadata_field_id=86 and (text_value='' OR text_value IS NULL);
item_id
---------
66841
(1 row)
dspace=# SELECT * FROM item, handle WHERE handle.resource_id = item.item_id AND item.item_id = '66841';
item_id | submitter_id | in_archive | withdrawn | last_modified | owning_collection | discoverable | handle_id | handle | resource_type_id | resource_id
---------+--------------+------------+-----------+----------------------------+-------------------+--------------+-----------+-------------+------------------+-------------
66841 | 1 | t | f | 2015-04-30 13:41:29.682+00 | 838 | t | 65272 | 10568/65272 | 2 | 66841
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment