Query linking pairs preList - Revision history

Ttenbergen at 19:24, 21 April 2022

2022-04-21T19:24:04Z

← Older revision		Revision as of 14:24, 21 April 2022
Line 21:		Line 21:

	== Log ==		== Log ==
	2021-07-28 - created query to replace hard coded SQL in VBA, both to fix linking pairs that took way longer in Access 2019 than it had in 2010, and to start using [[Service tmp entry]] dates rather than old [[Arrive DtTm field]], when available. [[User:Ttenbergen\|Ttenbergen]] 10:30, 2021 July 28 (CDT)		2021-07-28 - created query to replace hard coded SQL in VBA, both to fix linking pairs that took way longer in Access 2019 than it had in 2010, and to start using [[Service tmp entry]] dates rather than old Arrive DtTm field, when available. [[User:Ttenbergen\|Ttenbergen]] 10:30, 2021 July 28 (CDT)

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

Ttenbergen: /* SQL */

2021-08-04T14:31:59Z

SQL

← Older revision		Revision as of 09:31, 4 August 2021
Line 3:		Line 3:
	== SQL ==		== SQL ==
	See [[CFE]] for current version, but here is an instance:		See [[CFE]] for current version, but here is an instance:
	SELECT L_PHI~~.D_ID, L_PHI_moreThanOne~~.PHIN, created_AdmitDtTm.Admit_DtTm		SELECT L_PHI.PHIN,
	~~FROM ((~~		created_AdmitDtTm.Admit_DtTm,
	~~SELECT~~ L_PHI.~~PHIN~~, ~~Count(L_PHI~~.D_ID~~) AS CountOfD_ID~~		L_PHI.D_ID,
	FROM L_PHI		linking_pairs_LatestLinkedPHINAdmit.D_ID
	~~GROUP BY~~ L_PHI.~~PHIN~~		FROM (linking_pairs_multis
	~~HAVING (((Count(L_PHI~~.D_ID)~~)>1))~~		INNER JOIN ((L_PHI
	~~ORDER BY Count(~~L_PHI.D_ID)) ~~AS L_PHI_moreThanOne~~		INNER JOIN created_AdmitDtTm
	~~INNER JOIN L_PHI~~ ON ~~L_PHI_moreThanOne~~.PHIN = L_PHI.PHIN) INNER JOIN ~~created_AdmitDtTm~~ ON L_PHI.D_ID = created_AdmitDtTm.~~D_ID~~;		ON L_PHI.D_ID = created_AdmitDtTm.D_ID)
			LEFT JOIN linking_pairs_LatestLinkedPHINAdmit
			ON L_PHI.D_ID = linking_pairs_LatestLinkedPHINAdmit.D_ID)
			ON linking_pairs_multis.PHIN = L_PHI.PHIN)
			INNER JOIN linking_pairs_unlinkeds
			ON L_PHI.D_ID = linking_pairs_unlinkeds.D_ID
			WHERE (((linking_pairs_LatestLinkedPHINAdmit.D_ID) Is Not Null))
			OR (((linking_pairs_unlinkeds.D_ID) Is Not Null))
			ORDER BY L_PHI.PHIN, created_AdmitDtTm.Admit_DtTm;

	== Log ==		== Log ==

Ttenbergen: /* SQL */

2021-07-28T15:32:10Z

SQL

← Older revision		Revision as of 10:32, 28 July 2021
Line 3:		Line 3:
	== SQL ==		== SQL ==
	See [[CFE]] for current version, but here is an instance:		See [[CFE]] for current version, but here is an instance:
	SELECT L_PHI.D_ID, L_PHI_moreThanOne.PHIN, created_AdmitDtTm.Admit_DtTm		SELECT L_PHI.D_ID, L_PHI_moreThanOne.PHIN, created_AdmitDtTm.Admit_DtTm
	FROM ((SELECT L_PHI.PHIN, Count(L_PHI.D_ID) AS CountOfD_ID		FROM ((
	FROM L_PHI		SELECT L_PHI.PHIN, Count(L_PHI.D_ID) AS CountOfD_ID
	GROUP BY L_PHI.PHIN		FROM L_PHI
	HAVING (((Count(L_PHI.D_ID))>1))		GROUP BY L_PHI.PHIN
	ORDER BY Count(L_PHI.D_ID)) AS L_PHI_moreThanOne INNER JOIN L_PHI ON L_PHI_moreThanOne.PHIN = L_PHI.PHIN) INNER JOIN created_AdmitDtTm ON L_PHI.D_ID = created_AdmitDtTm.D_ID;		HAVING (((Count(L_PHI.D_ID))>1))
			ORDER BY Count(L_PHI.D_ID)) AS L_PHI_moreThanOne
			INNER JOIN L_PHI ON L_PHI_moreThanOne.PHIN = L_PHI.PHIN) INNER JOIN created_AdmitDtTm ON L_PHI.D_ID = created_AdmitDtTm.D_ID;

	== Log ==		== Log ==

Ttenbergen: /* Log */

2021-07-28T15:30:26Z

Log

← Older revision		Revision as of 10:30, 28 July 2021
Line 11:		Line 11:

	== Log ==		== Log ==
	2021-07-28 - created query to replace hard coded SQL in VBA		2021-07-28 - created query to replace hard coded SQL in VBA, both to fix linking pairs that took way longer in Access 2019 than it had in 2010, and to start using [[Service tmp entry]] dates rather than old [[Arrive DtTm field]], when available. [[User:Ttenbergen\|Ttenbergen]] 10:30, 2021 July 28 (CDT)

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

Ttenbergen at 15:26, 28 July 2021

2021-07-28T15:26:07Z

← Older revision		Revision as of 10:26, 28 July 2021
Line 1:		Line 1:
	Query linking_pairs_preList is a query in [[CFE]] that is used by [[Populate linking pairs]] for making [[linking_pairs table]].		Query linking_pairs_preList is a query in [[CFE]] that is used by [[Populate linking pairs]] for making [[linking_pairs table]].

			== SQL ==
			See [[CFE]] for current version, but here is an instance:
			SELECT L_PHI.D_ID, L_PHI_moreThanOne.PHIN, created_AdmitDtTm.Admit_DtTm
			FROM ((SELECT L_PHI.PHIN, Count(L_PHI.D_ID) AS CountOfD_ID
			FROM L_PHI
			GROUP BY L_PHI.PHIN
			HAVING (((Count(L_PHI.D_ID))>1))
			ORDER BY Count(L_PHI.D_ID)) AS L_PHI_moreThanOne INNER JOIN L_PHI ON L_PHI_moreThanOne.PHIN = L_PHI.PHIN) INNER JOIN created_AdmitDtTm ON L_PHI.D_ID = created_AdmitDtTm.D_ID;

			== Log ==
			2021-07-28 - created query to replace hard coded SQL in VBA

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

Ttenbergen: Created page with "Query linking_pairs_preList is a query in CFE that is used by Populate linking pairs for making linking_pairs table. == Related articles == {{Related Articles}}..."

2021-07-28T15:23:56Z

Created page with "Query linking_pairs_preList is a query in CFE that is used by Populate linking pairs for making linking_pairs table. == Related articles == {{Related Articles}}..."

New page

Query linking_pairs_preList is a query in [[CFE]] that is used by [[Populate linking pairs]] for making [[linking_pairs table]].

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

[[Category:Multiple Encounter linking]]
[[Category:Centralized data front end.accdb]]