reports (item usage) combination search broken

[kaibolay]

For example searching for "Subject" (e.g. Comics) and "Last checkout date" does not return any results.

[kaibolay]

It seems like all reports are broken - I don't observe any requests to the backend.

[kaibolay]

Aha! "Last checkout date" is a required field and needs to be set. If it's not set no request is sent - but also no error is displayed.

[kaibolay]

GET https://librarian.gssb.org/api/reports/itemUsage?category=Buch&lastCheckoutDate=2023-11-04 results in HTTP Status Code 400 Bad Request with

{
  "error": "SQL Error",
  "errorCode": "ER_PARSE_ERROR",
  "mesage": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 
      for the right syntax to use near 
      'where category = 'Buch'\n      group by a.barcode\n      having last_checkout_date' at line 3"
}

[kaibolay]

The SQL error was fixed with eed8e59

I still need to improve the feedback when no date is selected. Should display and error and highlight the date picker - or alternatively the field should be pre-populated (e.g. with today's date) so that it is always set.