CFE Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 1: Line 1:
__TOC__
This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:  
This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:  
* [[Pre-linking checks]]
* [[Pre-linking checks]]
Line 16: Line 18:
}}
}}


== List ==
== Currently active checks ==
Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented||needs review||ready to implement]] |format=count }}
{{#cargo_query:
{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented||needs review||ready to implement]]
tables=DataIntegrityChecks,Discussions,_pageData
|?DICStatus = Status
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|order=descending
|fields=
|limit=1000
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|format=broadtable
DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
|link=all
|where=App="CFE" and (Status<>"retired" and Status<>"declined")
|class=sortable wikitable smwtable
|order by=question
|limit=1000
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


{{#ask: [[DICApp::Centralized data front end.accdb]]
== All checks ==
|?DICStatus = Status
{{#cargo_query:
|?Modification date
tables=DataIntegrityChecks,Discussions,_pageData
|sort=Modification date
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|order=descending
|fields=
|limit=0
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|format=broadtable
DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
|link=all
|where=App="CFE"
|class=sortable wikitable smwtable
|order by=question
|searchlabel=Full list of queries including declined, retired, etc
|limit=1000
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


== Related articles ==  
== Related articles ==  

Revision as of 13:57, 2021 September 15

This page lists pages that have CFE Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:

See Template:Data Integrity Check for how to get things on this list.


Currently active checks

Nothing found

All checks

Nothing found



Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CFE_Data_Integrity_Checks&oldid=152007"