LP#2018534: treat year as numeric when retrieving item circs by year user/jeffdavis/lp2018534-numeric-circbyyr
authorJeff Davis <jeff.davis@bc.libraries.coop>
Thu, 4 May 2023 18:13:42 +0000 (11:13 -0700)
committerJeff Davis <jeff.davis@bc.libraries.coop>
Thu, 4 May 2023 18:13:42 +0000 (11:13 -0700)
commit6f6c70206a4f8a8eb95b180da682d54dc5625e95
tree6795427185a603a13d0710a5fd0880c7c89b6923
parent9aa747894e3caa84c4ec4fd406eda9973ac926be
LP#2018534: treat year as numeric when retrieving item circs by year

The open-ils.pcrud.search.circbyyr API uses EXTRACT to extract the year
from circulation timestamps.  In recent versions of Postgres, the return
type for EXTRACT was changed from double precision to numeric (thanks to
Jason Boyer for noticing this!); for obscure reasons, this causes pcrud
to return the year as a string instead of a number.  So, let's get the
staff client to force those values to be numbers before doing math with
them.

Signed-off-by: Jeff Davis <jeff.davis@bc.libraries.coop>
Open-ILS/web/js/ui/default/staff/cat/item/app.js