CCMDB Wiki

CFE Data Integrity Checks: Difference between revisions

← Older editNewer edit →
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 ==  
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CFE_Data_Integrity_Checks"