If I include "Lifetime" in an entity display of search results, and try to sort by "Lifetime" it explodes with a sql error (unknown column) lifespan
https://ca.pelhamhs.org/index.php/find/SearchEntities/Index/sort/ca_entities.lifespan
I guess entities has "life_sdatetime" and "life_edatetime" but no "lifespan"
This seems to be a problem sorting derived dates (lifespan is derived from "life_sdatetime" and "life_edatetime)
Looks like it also happens with object's "Date of disposal"
https://ca.pelhamhs.org/index.php/find/SearchObjects/Index/sort/ca_objects.deaccession_disposal_date also explodes with objects
accession_sdatetime accession_edatetime deaccession_sdatetime deaccession_edatetime but no "deaccession_disposal_date"
Bruce
Component Version
Application version 2.0
Schema revision 206
Release type GIT
System GUID d7668e63-ac98-45ca-9d83-015efeefbd14
Last change log ID 300010
PHP version 8.4.10
Operating system Linux ecngx342.inmotionhosting.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64
