MitIDErhverv - Revision history

Ori@inlogic.dk: /* FAQ */

2025-09-05T12:27:43Z

FAQ

← Older revision		Revision as of 12:27, 5 September 2025
Line 89:		Line 89:
	=== Find existing users ===		=== Find existing users ===
	The user must be active for UMS to find the user otherwise it will create a new user.		The user must be active for UMS to find the user otherwise it will create a new user.

			=== User can be found using the SQL Sentence criteria, why hasn't the user been created in ME? ===
			The user must have a WorkMail value in the Students table.

2025-06-16T08:19:53Z

SQL Sentence

2024-09-30T09:05:57Z

Authenticators

← Older revision		Revision as of 09:05, 30 September 2024
Line 18:		Line 18:
	Choose the authenticators to add to users.		Choose the authenticators to add to users.

	'''~~WARNING : If "~~Kodeviser", "Chip~~" or "~~Kodeoplæser~~" is chosen, it will result~~ in ~~immediately ordering of the hardware upon user creation.'''~~		'''Kodeviser, Chip and Kodeoplæser can be selected in setting without cost for customer.'''

	~~'''The hardware costs money, so be careful to get approval from~~ customer ~~before enabling these choices~~.'''

			'''The cost is generated when user selects the option at activation'''
	===SQL Sentence===		===SQL Sentence===
	Insert parameters for filtering purposes		Insert parameters for filtering purposes

2023-10-18T09:36:25Z

Authenticators

← Older revision		Revision as of 09:36, 18 October 2023
Line 17:		Line 17:
	=== Authenticators ===		=== Authenticators ===
	Choose the authenticators to add to users.		Choose the authenticators to add to users.

			'''WARNING : If "Kodeviser", "Chip" or "Kodeoplæser" is chosen, it will result in immediately ordering of the hardware upon user creation.'''

			'''The hardware costs money, so be careful to get approval from customer before enabling these choices.'''

	===SQL Sentence===		===SQL Sentence===

2023-04-12T10:55:16Z

SQL Sentence

← Older revision		Revision as of 10:55, 12 April 2023
Line 33:		Line 33:
	And (BirthDay Is Not Null)		And (BirthDay Is Not Null)
	And (Fornavne Is Not Null)		And (Fornavne Is Not Null)
	And (Fornavne <> '')		And (Fornavne <> <nowiki>''</nowiki>'')
	And (Efternavn Is Not Null)		And (Efternavn Is Not Null)
	And (Efternavn <> '')		And (Efternavn <> <nowiki>''</nowiki>'')
	And (WorkMail Is Not Null)		And (WorkMail Is Not Null)
	And (WorkMail <> '')		And (WorkMail <> <nowiki>''</nowiki>'')
	And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))		And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
	'''<Your SQL Sentence>'''		'''<Your SQL Sentence>'''

2023-04-12T10:55:00Z

SQL Sentence

← Older revision		Revision as of 10:55, 12 April 2023
Line 33:		Line 33:
	And (BirthDay Is Not Null)		And (BirthDay Is Not Null)
	And (Fornavne Is Not Null)		And (Fornavne Is Not Null)
	And (Fornavne <> '')''		And (Fornavne <> '')
	And (Efternavn Is Not Null)		And (Efternavn Is Not Null)
	And (Efternavn <> '')''		And (Efternavn <> '')
	And (WorkMail Is Not Null)		And (WorkMail Is Not Null)
	And (WorkMail <> '')''		And (WorkMail <> '')
	And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))		And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
	'''<Your SQL Sentence>'''		'''<Your SQL Sentence>'''

2023-03-16T07:53:18Z

SQL Sentence

← Older revision		Revision as of 07:53, 16 March 2023
Line 39:		Line 39:
	And (WorkMail <> '')''		And (WorkMail <> '')''
	And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))		And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
	<Your SQL Sentence>		'''<Your SQL Sentence>'''

	=== Parameters ===		=== Parameters ===

2023-03-16T07:52:55Z

SQL Sentence

← Older revision		Revision as of 07:52, 16 March 2023
Line 39:		Line 39:
	And (WorkMail <> '')''		And (WorkMail <> '')''
	And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))		And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
			<Your SQL Sentence>

	=== Parameters ===		=== Parameters ===

2023-03-16T07:52:44Z

SQL Sentence

← Older revision		Revision as of 07:52, 16 March 2023
Line 20:		Line 20:
	===SQL Sentence===		===SQL Sentence===
	Insert parameters for filtering purposes		Insert parameters for filtering purposes

			You can test it by using this SQL command and appending your own SQL sentence.

	Select Distinct Students.SLI_ID, Students.Fornavne As GivenName, Students.Efternavn As SurName, Students.CPR As CivilRegistrationNumber		Select Distinct Students.SLI_ID, Students.Fornavne As GivenName, Students.Efternavn As SurName, Students.CPR As CivilRegistrationNumber
Line 31:		Line 33:
	And (BirthDay Is Not Null)		And (BirthDay Is Not Null)
	And (Fornavne Is Not Null)		And (Fornavne Is Not Null)
	And (Fornavne <> '')		And (Fornavne <> '')''
	And (Efternavn Is Not Null)		And (Efternavn Is Not Null)
	And (Efternavn <> '')		And (Efternavn <> '')''
	And (WorkMail Is Not Null)		And (WorkMail Is Not Null)
	And (WorkMail <> '')		And (WorkMail <> '')''
	And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID ~~And MitIDErhverv_Users.MitIDErhvervSettings_ID = {(int~~)~~SettingsRow["ID"]}~~))		And (Not Exists (Select SLI_ID From MitIDErhverv_Users Where MitIDErhverv_Users.SLI_ID = Students.SLI_ID))
	~~Order By SLI_ID~~

	=== Parameters ===		=== Parameters ===

2023-03-16T07:51:40Z

SQL Sentence

@@ Line 20: / Line 20: @@
 ===SQL Sentence===
 Insert parameters for filtering purposes
 === Parameters ===