CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older editNewer edit →
mNo edit summary
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: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) ==
== Currently active checks ==
Current number of CCMDB.accdb Data Integrity Checks: {{#ask: [[DICApp::CCMDB.accdb]] [[DICStatus::!retired]] [[DICStatus::!declined]] [[DICStatus::!not feasible]] |format=count }}
{{#cargo_query:
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]] [[DICStatus::!retired]] [[DICStatus::!not feasible]] [[DICStatus::!declined]]
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, App, Status, Timing, Firmness, Summary, question, who
|order=asc
|where=App="CCMDB.accdb" and (Status<>"retired" and Status<>"declined")
|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
}}
}}


{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]]
== All checks ===
|?DICStatus = Status
{{#cargo_query:
|?DiscussQuestion = questions
tables=DataIntegrityChecks,Discussions,_pageData
|?DiscussWho = who
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|limit=0
|fields=
|searchlabel=Click here
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
}} to see all checks including retired and declined ones
DataIntegrityChecks._pageName=page, App, Status, Timing, Firmness, Summary, question, who
|where=App="CCMDB.accdb"
|order by=question
|limit=1000
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}


== Related articles ==  
== Related articles ==  
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks"