status_date in item_ext table stored as text instead of date

folio-org / folio-analytics

Community query repository for FOLIO analytics based on Metadb/LDP

Apache License 2.0

13 stars 30 forks source link

status_date in item_ext table stored as text instead of date #860

Open hutchinsonca opened 5 months ago

hutchinsonca commented 5 months ago

The folio_derived.item_ext table in metadB is storing status_date as long text rather than as date/time. This causes issues with existing queries (as it is a change from Orchid). Can it be instead stored in the appropriate date format?

sbeltaine commented 5 months ago

As long as we are updating this table, it would also be good to have effective_shelving_order field from the folio_inventory.item__t table in Metadb added (from Joanne Leary)