CCMDB.accdb Change Log 2023: Difference between revisions

Line 2: Line 2:
See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. See also '''[[requested CCMDB changes for the next version]]''' and '''[[CCMDB.accdb Data Integrity Checks]]'''.  
See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. See also '''[[requested CCMDB changes for the next version]]''' and '''[[CCMDB.accdb Data Integrity Checks]]'''.  


=== 2023-01-11 ===
=== 2023-01-25 ===
not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:04, 2023 January 5 (CST)
not rolled yet [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
<!----------------------------
<!----------------------------
not rolled yet ~~~~
not rolled yet ~~~~
Line 12: Line 12:


Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* 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. ~~~~
*
-->
 
=== 2023-01-11 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:26, 2023 January 25 (CST)
 
'''<mark>Changes collectors need to know about:</mark>'''
* added HSC ICU related Cognos services to [[s_tmp table]] to allow entry as it is in Cognos, rather than changed version; '''more may need to be added, let me know'''
 
Changes collectors probably don't care about (incl. bug fixes that should just make things work now):
* 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 Hospital in s_dispo table to replace the nulls in its site etc fields with empty strings like all the other entries have
Line 18: Line 28:
* 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
* disabled [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]
* disabled [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]]
-->


=== 2023-01-05 ===
=== 2023-01-05 ===