CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
m Text replacement - "CCMDB.mdb" to "CCMDB.accdb"
No edit summary
 
(12 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.accdb Data Integrity Checks: {{#ask: [[DICApp::CCMDB.accdb]] |format=count }}
{{#cargo_query:
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]]
tables=DataIntegrityChecks,Discussions,_pageData
|?DICStatus = Status
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|?DiscussQuestion = questions
|fields=
|?DiscussWho = who
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|sort=DICStatus
DataIntegrityChecks._pageName=page, Coding, Status, Timing, Firmness, Summary, question, who
|order=asc
|where=App="CCMDB.accdb" and (Status="needs review" or Status="ready to implement")
|limit=1000
|order by=question
|format=broadtable
|limit=1000
|link=all
|offset=some number
|class=sortable wikitable smwtable
|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"