Difference between revisions of "Query check tmp service or location duplicate"

From CCMDB Wiki
Jump to navigation Jump to search
m
 
(4 intermediate revisions by the same user not shown)
Line 9: Line 9:
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
.
 
{{Todo
This is almost but not quite the same as [[query check_tmp_2_BL_TR_S_same_tm]].  
| who = Tina
 
| todo_added = 2021-07-27
{{Todo  
| todo_action = 2021-08-10
| who = Tina
| question = _dev_CCMDB
| question = 
* evil twin of [[Query check tmp 2 Service tmp same time]], [[Query check tmp 2 Boarding Locs same time]], [[Query check tmp 2 Transfer Ready same time]]
* we also need to check whether there is a duplicate dttm on DIFFERENT items; same query or better in a different one
| todo_added = 2021-09-02
| todo_action = 2021-09-02
}}
}}
== Log ==
== Log ==
* 2021-09-02 - removed "item" from listing since we don't allow duplicates even if the item is different, and removed the exclusion of ER records from check
* 2021-05-04 - changed query to catch a scenario I had not thought of earlier
* 2021-05-04 - changed query to catch a scenario I had not thought of earlier
* 2021-01-15 - check implemented
* 2021-01-15 - check implemented

Latest revision as of 14:46, 2021 September 2

Data Integrity Checks
Summary: Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments
Related: Service tmp entry, Boarding_Loc
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_tmp_service_or_location_duplicate
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-15
Backlogged: No


  • Cargo


  • SMW


  • Categories: 

This is almost but not quite the same as query check_tmp_2_BL_TR_S_same_tm.

Todo.svg

Swiss Army Knife.svg

  • we also need to check whether there is a duplicate dttm on DIFFERENT items; same query or better in a different one
  • added: 2021-09-02
  • action: 2021-09-02
  • Cargo


  • Categories

Log

  • 2021-09-02 - removed "item" from listing since we don't allow duplicates even if the item is different, and removed the exclusion of ER records from check
  • 2021-05-04 - changed query to catch a scenario I had not thought of earlier
  • 2021-01-15 - check implemented

Related articles

Related articles: