CFE Data Integrity Checks - Revision history

Ttenbergen: /* All checks */

2021-09-15T19:02:43Z

All checks

← Older revision		Revision as of 14:02, 15 September 2021
Line 32:		Line 32:
	\|where=App="Centralized data front end.accdb "		\|where=App="Centralized data front end.accdb "
	\|order by=question		\|order by=question
	\|limit=~~1000~~		\|limit=0
	\|~~offset~~=~~some number~~		\|more results text=see all checks
	\|default=Nothing found		\|default=Nothing found
	\|format=dynamic table		\|format=dynamic table
	\|rows per page=1000		\|rows per page=1000
	}}		}}




	== Related articles ==		== Related articles ==

Ttenbergen at 18:59, 15 September 2021

2021-09-15T18:59:25Z

← Older revision		Revision as of 13:59, 15 September 2021
Line 6:		Line 6:

	See [[Template:Data Integrity Check]] for how to get things on this list.		See [[Template:Data Integrity Check]] for how to get things on this list.

	~~{{#ask: [[DICApp::CFE]]~~
	~~\|?Has IntegrityCheckStatus = Status~~
	~~\|?Modification date~~
	~~\|sort=Modification date~~
	~~\|order=ascending~~
	~~\|limit=10000~~
	~~\|format=broadtable~~
	~~\|link=all~~
	~~\|class=sortable wikitable smwtable~~
	}}

	== Currently active checks ==		== Currently active checks ==
Line 25:		Line 14:
	CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,		CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
	DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who		DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
	\|where=App="~~CFE~~" and (Status<>"retired" and Status<>"declined")		\|where=App="Centralized data front end.accdb " and (Status<>"retired" and Status<>"declined")
	\|order by=question		\|order by=question
	\|limit=1000		\|limit=1000
Line 41:		Line 30:
	CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,		CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
	DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who		DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
	\|where=App="~~CFE~~"		\|where=App="Centralized data front end.accdb "
	\|order by=question		\|order by=question
	\|limit=1000		\|limit=1000

Ttenbergen at 18:57, 15 September 2021

2021-09-15T18:57:25Z

← Older revision		Revision as of 13:57, 15 September 2021
Line 1:		Line 1:
			__TOC__

	This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:		This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:
	* [[Pre-linking checks]]		* [[Pre-linking checks]]
Line 16:		Line 18:
	}}		}}

	== ~~List~~ ==		== Currently active checks ==
	~~Current number of CFE Data Integrity Checks:~~ {{#~~ask~~: ~~[[DICApp::Centralized data front end~~.~~accdb]][[DICStatus::implemented\|\|needs review\|~~\|~~ready to implement]] \|format~~=~~count }}~~		{{#cargo_query:
	{{~~#ask: [[DICApp~~:~~:Centralized data front end~~.~~accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]~~]		tables=DataIntegrityChecks,Discussions,_pageData
	\|~~?DICStatus~~ = Status		\|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
	\|order=~~descending~~		\|fields=
	\|limit=1000		CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
	\|~~format~~=~~broadtable~~		DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
	\|~~link~~=~~all~~		\|where=App="CFE" and (Status<>"retired" and Status<>"declined")
	\|~~class~~=~~sortable wikitable smwtable~~		\|order by=question
			\|limit=1000
			\|offset=some number
			\|default=Nothing found
			\|format=dynamic table
			\|rows per page=1000
	}}		}}

	{{#~~ask~~: [~~[DICApp~~:~~:Centralized data front end~~.~~accdb]~~]		== All checks ==
	~~\|?DICStatus~~ = Status		{{#cargo_query:
	\|~~?Modification date~~		tables=DataIntegrityChecks,Discussions,_pageData
	~~\|sort~~=~~Modification date~~		\|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
	\|order=~~descending~~		\|fields=
	\|limit=0		CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit,
	\|~~format~~=~~broadtable~~		DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who
	\|~~link~~=~~all~~		\|where=App="CFE"
	\|~~class~~=~~sortable wikitable smwtable~~		\|order by=question
	\|~~searchlabel~~=~~Full list of queries including declined, retired, etc~~		\|limit=1000
			\|offset=some number
			\|default=Nothing found
			\|format=dynamic table
			\|rows per page=1000
	}}		}}




	== Related articles ==		== Related articles ==

Ttenbergen: /* SMW LIST */

2021-07-15T21:30:58Z

SMW LIST

← Older revision		Revision as of 16:30, 15 July 2021
Line 16:		Line 16:
	}}		}}

	== ~~SMW LIST~~ ==		== List ==
	Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]] \|format=count }}		Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]] \|format=count }}
	{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]		{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]

Ttenbergen: /* SMW LIST */

2021-07-15T20:20:55Z

SMW LIST

← Older revision		Revision as of 15:20, 15 July 2021
Line 20:		Line 20:
	{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]		{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]
	\|?DICStatus = Status		\|?DICStatus = Status
	~~\|?Modification date~~
	\|order=descending		\|order=descending
	\|limit=1000		\|limit=1000

Ttenbergen: /* SMW LIST */

2021-07-15T20:20:33Z

SMW LIST

← Older revision		Revision as of 15:20, 15 July 2021
Line 21:		Line 21:
	\|?DICStatus = Status		\|?DICStatus = Status
	\|?Modification date		\|?Modification date
	~~\|sort=Modification date~~
	\|order=descending		\|order=descending
	\|limit=1000		\|limit=1000

Ttenbergen: /* SMW LIST */

2021-07-15T20:20:05Z

SMW LIST

← Older revision		Revision as of 15:20, 15 July 2021
Line 17:		Line 17:

	== SMW LIST ==		== SMW LIST ==
	Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb ]] \|format=count }}		Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]] \|format=count }}
	{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]		{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]
	\|?DICStatus = Status		\|?DICStatus = Status

Ttenbergen: /* SMW LIST */

2021-07-15T20:19:37Z

SMW LIST

← Older revision		Revision as of 15:19, 15 July 2021
Line 18:		Line 18:
	== SMW LIST ==		== SMW LIST ==
	Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb ]] \|format=count }}		Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb ]] \|format=count }}
			{{#ask: [[DICApp::Centralized data front end.accdb]][[DICStatus::implemented\|\|needs review\|\|ready to implement]]
			\|?DICStatus = Status
			\|?Modification date
			\|sort=Modification date
			\|order=descending
			\|limit=1000
			\|format=broadtable
			\|link=all
			\|class=sortable wikitable smwtable
			}}

	{{#ask: [[DICApp::Centralized data front end.accdb]]		{{#ask: [[DICApp::Centralized data front end.accdb]]
	\|?DICStatus = Status		\|?DICStatus = Status
Line 23:		Line 34:
	\|sort=Modification date		\|sort=Modification date
	\|order=descending		\|order=descending
	\|limit=~~1000~~		\|limit=0
	\|format=broadtable		\|format=broadtable
	\|link=all		\|link=all
	\|class=sortable wikitable smwtable		\|class=sortable wikitable smwtable
			\|searchlabel=Full list of queries including declined, retired, etc
	}}		}}

			== Related articles ==
			{{Related Articles}}


	[[Category:Data Integrity Checks\| *]]		[[Category:Data Integrity Checks\| *]]
	[[Category:CFE Data Integrity Checks\| *]]		[[Category:CFE Data Integrity Checks\| *]]

Ttenbergen at 20:54, 4 July 2019

2019-07-04T20:54:30Z

← Older revision		Revision as of 15:54, 4 July 2019
Line 1:		Line 1:
	This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available.		This page lists pages that have [[CFE]] Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:
			* [[Pre-linking checks]]
			* [[Quality Assurance queries in CFE]]

	See [[Template:Data Integrity Check]] for how to get things on this list.		See [[Template:Data Integrity Check]] for how to get things on this list.
Line 12:		Line 14:
	\|link=all		\|link=all
	\|class=sortable wikitable smwtable		\|class=sortable wikitable smwtable
	}}

	~~{{DT \|~~
	* information that still needs to be integrated
	** [[Pre-linking checks]]
	** [[Quality Assurance queries in CFE]]
	}}		}}

Ttenbergen at 16:44, 11 February 2019

2019-02-11T16:44:07Z

← Older revision		Revision as of 11:44, 11 February 2019
Line 15:		Line 15:

	{{DT \|		{{DT \|
	* information that still needs to be integrated ==		* information that still needs to be integrated
	** [[Pre-linking checks]]		** [[Pre-linking checks]]
	** [[Quality Assurance queries in CFE]]		** [[Quality Assurance queries in CFE]]