CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
mNo edit summary
No edit summary
 
(34 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
}}
}}


== All ==
== Currently active 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=0
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
}}
}}


[[Category:CCMDB Data Integrity Checks|*]]
== 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| *]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks"