CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
m Ttenbergen moved page CCMDB Data Integrity Checks List to CCMDB Data Integrity Checks without leaving a redirect: consistency
No edit summary
 
(29 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.  


== Those that need review ==
See [[Template:Data Integrity Check]] for how to get things on this list.
{{#ask: [[Category:CCMDB Data Integrity Checks]] [[Has IntegrityCheckStatus::needs review]]
 
|?Has IntegrityCheckStatus = 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=10000
|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
}}
}}


== Those that are ready to implement ==
== Currently active checks ==
{{#ask: [[Category:CCMDB Data Integrity Checks]] [[Has IntegrityCheckStatus::ready to implement]]
{{#cargo_query:
|?Has IntegrityCheckStatus = Status
tables=DataIntegrityChecks,Discussions,_pageData
|?Modification date
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|sort=Modification date
|fields=
|order=ascending
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|limit=1000
DataIntegrityChecks._pageName=page, Coding, Status, Timing, Firmness, Summary, question, who
|format=broadtable
|where=App="CCMDB.accdb" and (Status<>"retired" and Status<>"declined" and Status<>"not feasible")
|link=all
|order by=question
|class=sortable wikitable smwtable
|limit=1000
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


== All ==
== All checks ==
{{#ask: [[Category:CCMDB Data Integrity Checks]]  
{{#cargo_query:
|?Has IntegrityCheckStatus = Status
tables=DataIntegrityChecks,Discussions,_pageData
|?Modification date
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|sort=Modification date
|fields=
|order=ascending
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|limit=1000
DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
|format=broadtable
|where=App="CCMDB.accdb"
|link=all
|order by=question
|class=sortable wikitable smwtable
|limit=0
|more results text=see all checks
|offset=some number
|default=Nothing found
|format=dynamic table
|rows per page=1000
}}
}}


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