CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
m →old style templating: old template all gone
No edit summary
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
__TOC__
This page lists pages that have CCMDB Data Integrity Checks on them, the status of those checks if available, and the page's last modification date.  
This page lists pages that have CCMDB Data Integrity Checks on them, the status of those checks if available, and the page's last modification date.  


See [[Template:CCMDB Data Integrity Checks]] for how to get things on this list.  
See [[Setting up a new CCMDB Data Integrity Check]] for how these are set up.
== new style templating ==
 
using [[Template:Data Integrity Check]]
See [[Template:Data Integrity Check]] for how to get things on this list.  
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.mdb]]
 
|?DICStatus = Status
== Checks currently requiring action ==
|?Modification date
{{#cargo_query:
|sort=Modification date
tables=DataIntegrityChecks,Discussions,_pageData
|order=ascending
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|limit=1000
|fields=
|format=broadtable
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|link=all
DataIntegrityChecks._pageName=page, Coding, Status, Timing, Firmness, Summary, question, who
|class=sortable wikitable smwtable
|where=App="CCMDB.accdb" and (Status="needs review" or Status="ready to implement")
|order by=question
|limit=1000
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
 
== Currently active 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, Coding, Status, Timing, Firmness, Summary, question, who
|where=App="CCMDB.accdb" and (Status<>"retired" and Status<>"declined" and Status<>"not feasible")
|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="CCMDB.accdb"
|order by=question
|limit=0
|more results text=see all checks
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


== Related articles ==
{{Related Articles}}


[[Category:CCMDB Data Integrity Checks| *]]
[[Category:Data Integrity Checks| *]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks"