Query check CCI Component no admin entries: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Data Integrity Check | DIC_summary = There must be no No procedure entered/Blank procedure entry in CCI Component. | DIC_related_concepts = CCI Component; No procedure entered; Blank procedure entry | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''check_CCI_Component_if_no_admin_entries'' | DIC_status = implemented | DIC_implementation_date = 2018-10-14 }} == Log == * 2023-02-08 - broke original query in t..."
 
Line 11: Line 11:


== Log ==
== Log ==
* 2023-11-25 - found this to have "*" selected and to not be properly editable, fixed
* 2023-02-08 - broke original query in two and fixed it
* 2023-02-08 - broke original query in two and fixed it
* 2018-10-14 - initially implemented  as one query to check both picklist and component list, but wasn't working right
* 2018-10-14 - initially implemented  as one query to check both picklist and component list, but wasn't working right

Revision as of 10:03, 25 November 2023

Data Integrity Checks
Summary: There must be no No procedure entered/Blank procedure entry in CCI Component.
Related: CCI Component, No procedure entered, Blank procedure entry
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_CCI_Component_if_no_admin_entries
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2018-10-14
Backlogged: true
  • Cargo


  • SMW


  • Categories:  
  • form:

Log

  • 2023-11-25 - found this to have "*" selected and to not be properly editable, fixed
  • 2023-02-08 - broke original query in two and fixed it
  • 2018-10-14 - initially implemented as one query to check both picklist and component list, but wasn't working right

Related articles

Related articles: