CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
mNo edit summary
No edit summary
 
(18 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 [[Setting up a new CCMDB Data Integrity Check]] for how these are set up.


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.  


== CCMDB Data Integrity Checks (SMW) ==
== Checks currently requiring action ==
Current number of CCMDB.mdb Data Integrity Checks: {{#ask: [[DICApp::CCMDB.mdb]] |format=count }}
{{#cargo_query:
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.mdb]]
tables=DataIntegrityChecks,Discussions,_pageData
|?DICStatus = Status
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|?DiscussQuestion = questions
|fields=
|sort=DICStatus, <!-- empty after comma will sort by mainlabel as well-->
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|order=ascending
DataIntegrityChecks._pageName=page, Coding, Status, Timing, Firmness, Summary, question, who
|limit=1000
|where=App="CCMDB.accdb" and (Status="needs review" or Status="ready to implement")
|format=broadtable
|order by=question
|link=all
|limit=1000
|class=sortable wikitable smwtable
|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: Data Integrity Checks| *]]
[[Category:Data Integrity Checks| *]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks"