Videos/Search by ranges/Dates: issues

[costaflavio]

Expected behavior

The range selection by date should work also by year only (i.e. [2013 TO 2014]) as it happens in Zenodo (i.e. publicationdate:[2013 TO 2014])

Note: Search Guide to be amended

Actual behavior

Unfortunately there are issues:

• date field date:[2013 TO 2014] returns "internal error"

• publication_date field returns wrong results, see https://videos.cern.ch/search?page=1&size=21&q=publication_date:%5B1900%20TO%202005%5D

  many records have publication date after 2005, e.g https://videos.cern.ch/record/2060893

• apparently also queries with full dates values returns wrong results, e.g. https://videos.cern.ch/search?page=1&size=21&q=publication_date:%5B2010-01-01%20TO%20*%5D%20and%20date:%7B2017-12-01%20TO%20*%5D&years=1955--2007&sort=mostrecent

see the snapshot:

there should be no result, indeed the first video has date 2017-12-01 and all other are more recent (see sorting), so they all do not apply the part of the query after the AND

Information about the Issue

videos.cern.ch on 2018-06-19, Chrome 67 According to a first check by Nicola, date is mapped as a date (as publicationdate is mapped in Zenodo), while publication_date is mapped as string, so it is not clear why it does not work.

Steps to reproduce the behavior

Try what mentioned above

[ludmilamarian]

@costaflavio Actually your last query is not fully correct. It should be: https://videos.cern.ch/search?page=1&size=21&q=publication_date:%5B2010-01-01%20TO%20*%5D%20AND%20date:%5B2017-12-01%20TO%20*%5D (and this one seems to work)

Remember to use the capital AND instead of lower andas a operator for search queries (this info should be in the search guide as well, if it is not yet the case.)