CFE Data Integrity Checks: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available.
+__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:
+* [[Pre-linking checks]]
+* [[Quality Assurance queries in CFE]]
 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
+|default=Nothing found
+|format=dynamic table
+|rows per page=1000
+}}
+== All checks ==
+{{#cargo_query:
+tables=DataIntegrityChecks,Discussions,_pageData
+|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
+|fields=
+CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
+DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
+|where=App="Centralized data front end.accdb "
+|order by=question
+|limit=0
+|more results text=see all checks
+|default=Nothing found
+|format=dynamic table
+|rows per page=1000
 }}
-== information that still needs to be integrated ==
+== Related articles ==
-* [[Pre-linking checks]]
+{{Related Articles}}
-* [[Quality Assurance queries in CFE]]
-== SMW LIST ==
-Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb ]] |format=count }}
-{{#ask: [[DICApp::Centralized data front end.accdb]]
- |?DICStatus = Status
- |?Modification date
- |sort=Modification date
- |order=ascending
- |limit=1000
- |format=broadtable
- |link=all
- |class=sortable wikitable smwtable
-}}
 [[Category:Data Integrity Checks| *]]
 [[Category:CFE Data Integrity Checks| *]]