CCMDB Wiki

CFE Data Integrity Checks: Difference between revisions

← Older edit
 
(4 intermediate revisions by the same user not shown)
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 5: Line 7:
See [[Template:Data Integrity Check]] for how to get things on this list.  
See [[Template:Data Integrity Check]] for how to get things on this list.  


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


{{#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="Centralized data front end.accdb "
|class=sortable wikitable smwtable
|order by=question
|searchlabel=Full list of queries including declined, retired, etc
|limit=0
|more results text=see all checks
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


Retrieved from "https://ccmdb.kuality.ca/index.php?title=CFE_Data_Integrity_Checks"