Missing Date of Information - Revision history

Alnaucler at 05:30, 11 November 2016

2016-11-11T05:30:56Z

← Older revision		Revision as of 07:30, 11 November 2016
Line 1:		Line 1:
	{{TOC right}}		{{TOC right}}
	{{Note \| The Summary item/window calculation is '''depending''' on that ''Date of Information'' is filled in and the rules for if a DEF is Unapprovable are also depending on ''Date of Information''.}}		{{Note \| The Summary item/window calculation is '''depending''' on that ''Date of Information'' is filled in and the rules for if a DEF is Unapprovable are also depending on ''Date of Information''.
			There is a PostgreSQL version of this page '''[[Missing Date of Information PGSQL \| too]]'''.}}

	==Missing Date of Information ==__NOEDITSECTION__		==Missing Date of Information ==__NOEDITSECTION__
Line 218:		Line 219:
	AND		AND
	hazardinfoversion.link_only = '0' AND		hazardinfoversion.link_only = '0' AND
	hazardinfoversion.dataentrydate IS NOT NULL		hazardinfoversion.dataentrydate IS NOT NULL AND
			hazardinfoversion.dataentrydate < fieldreport.reportreceiveddate
	</pre>		</pre>

Alnaucler at 15:55, 10 November 2016

2016-11-10T15:55:48Z

@@ Line 1: / Line 1: @@
 {{TOC right}}
 ==Missing Date of Information ==__NOEDITSECTION__
 [[Image:Missing date info.png|1000px|center]]
@@ Line 204: / Line 206: @@
 InfoVerDate ASC,
 `Form ID` ASC
 </pre>

Alnaucler at 15:45, 10 November 2016

2016-11-10T15:45:36Z

Show changes

Alnaucler at 15:15, 10 November 2016

2016-11-10T15:15:53Z

← Older revision		Revision as of 17:15, 10 November 2016
Line 1:		Line 1:
	If Date of Information is missing it has to be set ~~depending on type of item~~. If the ~~Data Entry Form~~ that misses Date of Information is an Activity or Education then you might be able to use End date.		{{TOC right}}
			==Missing Date of Information ==__NOEDITSECTION__
			[[Image:Missing date info.png\|1000px\|center]]
			<div align="center">
			'' How it should NOT look like''
			</div>
			If ''Date of Information'' is missing it has to be set. If the DEF that misses ''Date of Information'' is an Activity or Education then you might be able to use ''End date''.
	<pre>		<pre>
	SELECT		SELECT
	fieldreport.fieldreport_localid,		fieldreport.fieldreport_localid AS `Form ID`,
	fieldreport.dateofreport AS `Date of Information`,		fieldreport.dateofreport AS `Date of Information`,
	fieldreport.reportreceiveddate AS `Data Entry Date`,		fieldreport.reportreceiveddate AS `Data Entry Date`,
Line 8:		Line 14:
	fieldreport.reportverifieddate AS `Approved Date`,		fieldreport.reportverifieddate AS `Approved Date`,
	fieldreport.dataenterer AS `Data enterer`,		fieldreport.dataenterer AS `Data enterer`,
	fieldreport.verifiedby AS `Approved by`		fieldreport.verifiedby AS `Approved by`,
			imsmaenum.enumvalue AS `WB status`
	FROM		FROM
	fieldreport		fieldreport
			INNER JOIN imsmaenum ON fieldreport.workbenchstatusenum_guid = imsmaenum.imsmaenum_guid
	WHERE		WHERE
	fieldreport.dateofreport IS NULL		fieldreport.dateofreport IS NULL
	ORDER BY		ORDER BY
	~~fieldreport~~.~~fieldreport_localid~~ ASC		imsmaenum.enumvalue DESC, `Form ID` ASC
	</pre>		</pre>
	~~'''Hazard'''~~

	With this result set you can show the country which Hazards are affected and figure out a solution		If you have any output here you need to take action. The queries below help you to identify for which item(s) the rows in the table ''fieldreport'' need to be updated.

			=== Hazard===__NOEDITSECTION__
			[[Image:Missing date info2.png\|1000px\|center]]
			<div align="center">
			'' Example of result - it is '''important''' to decide where you may find a date to use that is in chronological order. ''
			</div>
			With this result set you can show the country which Hazards are affected and figure out a solution.
	<pre>		<pre>
	SELECT		SELECT
	fieldreport.fieldreport_localid,		fieldreport.fieldreport_localid AS `Form ID`,
	fieldreport.dateofreport AS `Date of Information`,		fieldreport.dateofreport AS `Date of Information`,
	fieldreport.reportreceiveddate AS `Data Entry Date`,		fieldreport.reportreceiveddate AS `Data Entry Date`,
Line 28:		Line 42:
	fieldreport.dataenterer AS `Data enterer`,		fieldreport.dataenterer AS `Data enterer`,
	fieldreport.verifiedby AS `Approved by`,		fieldreport.verifiedby AS `Approved by`,
	hazardinfoversion.~~hazard_localid~~		imsmaenum.enumvalue AS `WB status`,
			hazardinfoversion.dataentrydate AS InfoVerDate
	FROM		FROM
	fieldreport		fieldreport
	~~Inner Join~~ hazardinfoversion ON fieldreport.fieldreport_guid = hazardinfoversion.fieldreport_guid		INNER JOIN hazardinfoversion ON fieldreport.fieldreport_guid = hazardinfoversion.fieldreport_guid
			INNER JOIN imsmaenum ON fieldreport.workbenchstatusenum_guid = imsmaenum.imsmaenum_guid
	WHERE		WHERE
	fieldreport.dateofreport IS NULL AND		fieldreport.dateofreport IS NULL AND
	hazardinfoversion.link_only = '0'		hazardinfoversion.link_only = '0'
	ORDER BY		ORDER BY
	~~fieldreport.fieldreport_localid~~ ASC		InfoVerDate ASC,
			`Form ID` ASC
	</pre>		</pre>
	~~'''Hazard reduction'''~~

			=== Hazard reduction===__NOEDITSECTION__
	With this result set you can show the country which Hazard Reductions are affected and figure out a solution e.g. use End date if NOT NULL		With this result set you can show the country which Hazard Reductions are affected and figure out a solution e.g. use End date if NOT NULL
	<pre>		<pre>
Line 63:		Line 80:
	</pre>		</pre>

			=== Accident===__NOEDITSECTION__
			<pre>
			</pre>
			=== Victim===__NOEDITSECTION__
			<pre>
			</pre>
			=== MRE===__NOEDITSECTION__
			<pre>
			</pre>
			=== QM===__NOEDITSECTION__
			<pre>
			</pre>
			=== Location===__NOEDITSECTION__
			<pre>
			</pre>

			==Future date==__NOEDITSECTION__
	Date of Information in the '''future'''. Use one day after the backup was taken in the WHERE.		Date of Information in the '''future'''. Use one day after the backup was taken in the WHERE.
	<pre>		<pre>

Alnaucler at 18:02, 7 April 2015

2015-04-07T18:02:20Z

← Older revision		Revision as of 20:02, 7 April 2015
Line 63:		Line 63:
	</pre>		</pre>

			Date of Information in the '''future'''. Use one day after the backup was taken in the WHERE.
			<pre>
			SELECT
			fieldreport.fieldreport_localid,
			fieldreport.dateofreport
			FROM
			fieldreport
			WHERE
			fieldreport.dateofreport > '2015-04-07'
			Order by 2
			</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Dionysia at 08:29, 13 February 2014

2014-02-13T08:29:12Z

← Older revision		Revision as of 10:29, 13 February 2014
Line 62:		Line 62:
	fieldreport.fieldreport_localid ASC		fieldreport.fieldreport_localid ASC
	</pre>		</pre>

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 09:10, 12 February 2014

2014-02-12T09:10:40Z

@@ Line 35: / Line 35: @@
 fieldreport.dateofreport IS NULL  AND
 hazardinfoversion.link_only =  '0'
 ORDER BY
 fieldreport.fieldreport_localid ASC

Alnaucler at 08:55, 12 February 2014

2014-02-12T08:55:06Z

← Older revision		Revision as of 10:55, 12 February 2014
Line 17:		Line 17:
	</pre>		</pre>
	'''Hazard'''		'''Hazard'''

	With this result set you can show the country which Hazards are affected and figure out a solution		With this result set you can show the country which Hazards are affected and figure out a solution
	<pre>		<pre>

Alnaucler at 08:54, 12 February 2014

2014-02-12T08:54:43Z

← Older revision		Revision as of 10:54, 12 February 2014
Line 17:		Line 17:
	</pre>		</pre>
	'''Hazard'''		'''Hazard'''
			With this result set you can show the country which Hazards are affected and figure out a solution
	<pre>		<pre>
	SELECT		SELECT

Alnaucler at 08:52, 12 February 2014

2014-02-12T08:52:40Z

@@ Line 13: / Line 13: @@
 WHERE
 fieldreport.dateofreport IS NULL
 ORDER BY
 fieldreport.fieldreport_localid ASC