search

AtlasOfLivingAustralia / specieslist-webapp

Species lists and traits tool
https://lists.ala.org.au
Mozilla Public License 2.0
6 stars 21 forks source link

Lists outage #306

Closed peggynewman closed 1 month ago

peggynewman commented 3 months ago

Going to these URLs is erroring

https://lists.ala.org.au/speciesListItem/list/dr2201?fq=family%28matched%29%3AProteaceae&q=&max=100 https://lists.ala.org.au/speciesListItem/list/dr649?fq=family%28matched%29%3AOrchidaceae&q=&max=100

Unable to retrieve species list items. Please let us know if this error persists. 
Error:
could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
adam-collins commented 3 months ago

To reproduce this error

  1. Open a list https://lists.ala.org.au/speciesListItem/list/dr2201
  2. On the left hand side, under the filter heading family(matched), click any item
  3. The fq is incorrect. It should filter the the result by the MatchedSpecies.family table join.

Fixing this requres

  1. Change family(matched) to something else. I think kvp filters work with kvp key:value so being consistent results in matched key:value, e.g. matched family:Proteaceae.
  2. Parse the matched prefix, in QueryService in a similar way to kvp.