CCMDB.accdb Change Log 2023: Difference between revisions

m Text replacement - "cross checks" to "cross checks"
 
Line 369: Line 369:
* updated [[S_laptops table]] to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
* updated [[S_laptops table]] to not allow duplicate entries. Three lines had accidentally been added that were causing records to not show up in CSS. [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
* changed the dropdown for the [[Previous Location]] to list the local entries first.  
* changed the dropdown for the [[Previous Location]] to list the local entries first.  
* updated entry for Selkirk Mental Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
* updated entry for [[Selkirk Mental Health Centre]] in [[s_dispo table]] to replace the nulls in its site etc fields with empty strings like all the other entries have
* updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use  
* updated the GH-ambulatory care to GH ambulatory care (- to space) so it sorts below the options collectors actually use  
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates