Query check tmp service or location duplicate

From CCMDB Wiki
Revision as of 15:09, 2021 August 26 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
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:  
  • form:

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


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


  • Categories

Log

  • 2021-05-04 - changed query to catch a scenario I had not thought of earlier
  • 2021-01-15 - check implemented

Related articles

Related articles: