CCMDB.accdb Data Integrity Checks: Difference between revisions
Ttenbergen (talk | contribs) Created page with "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. {{Discussion}} Tina to m..." |
Ttenbergen (talk | contribs) No edit summary |
||
| (37 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. | |||
== Checks currently requiring action == | |||
{{#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="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 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: | [[Category:Data Integrity Checks| *]] | ||