Known data errors: Difference between revisions
Ttenbergen (talk | contribs) m →Location of List of old known errors: moved details to Gaps and overlaps |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
== List of queries that use [[L_Problem table]] (SMW) == | == List of queries that use [[L_Problem table]] (SMW) == | ||
(Based on [[Property:DICLProblem]] as set in [[Template:Data Integrity Check]].) | (Based on [[Property:DICLProblem]], [[Property:DICStatus]] as set in [[Template:Data Integrity Check]].) | ||
{{#ask: [[DICLProblem:: | {{#ask: [[DICStatus::not entered||implemented||ready to implement||needs review]] [[DICLProblem::true]] | ||
|?DICStatus = Status | |?DICStatus = Status | ||
|?DICLProblem = problem | |||
|sort=Modification date | |sort=Modification date | ||
|order=ascending | |order=ascending | ||
| Line 22: | Line 23: | ||
|link=all | |link=all | ||
|class=sortable wikitable smwtable | |class=sortable wikitable smwtable | ||
}} | |||
Cargo | |||
{{#cargo_query: | |||
tables=DataIntegrityChecks,Discussions,_pageData | |||
|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName | |||
|fields= | |||
DataIntegrityChecks._pageName=page, Status, Timing, Summary, Status | |||
|where=App="Centralized data front end.accdb " and (Status<>"retired" and Status<>"declined") and (L_Problem=true or L_Problem is null) | |||
|order by=question | |||
|limit=20 | |||
|more results text=Link to table of cross-checks that use L_Problem table to exclude false-positives | |||
|default=Nothing found | |||
|format=dynamic table | |||
|rows per page=20 | |||
}} | }} | ||
| Line 32: | Line 48: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||