CCMDB Wiki

CCMDB.accdb Data Integrity Checks: Difference between revisions

← Older edit
mNo edit summary
No edit summary
 
(36 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.  


== Those that need review ==
See [[Setting up a new CCMDB Data Integrity Check]] for how these are set up.
{{#ask: [[Category:CCMDB Data Integrity Checks]] [[Has IntegrityCheckStatus::needs review]]
 
|?Has IntegrityCheckStatus = Status
See [[Template:Data Integrity Check]] for how to get things on this list.
|?Modification date
 
|sort=Has ICD10Code
== Checks currently requiring action ==
|order=ascending
{{#cargo_query:
|limit=10000
tables=DataIntegrityChecks,Discussions,_pageData
|format=broadtable
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
|link=all
|fields=
|class=sortable wikitable smwtable
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
DataIntegrityChecks._pageName=page, Coding, Status, Timing, Firmness, Summary, question, who
|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
}}
 
== 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 ==
== 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=Has ICD10Code
|fields=
|order=ascending
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
|limit=0
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"