Custom SQL Commands - Revision history

Kia: /* Add users to groups */

2022-09-30T12:04:30Z

Add users to groups

← Older revision		Revision as of 12:04, 30 September 2022
Line 38:		Line 38:
	This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.		This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.

	If you only want users with active groups ~~use~~ this extra SQL sentence		If you only want users with 1 or more active groups add this extra SQL sentence

	And ((Select Case When IsNull(Slutdato, <nowiki>''</nowiki>) = <nowiki>''</nowiki> Then GetDate() + 100 Else Convert(DateTime2, Slutdato, 105) End) >= Convert(Date, GetDate()))		And ((Select Case When IsNull(Slutdato, <nowiki>''</nowiki>) = <nowiki>''</nowiki> Then GetDate() + 100 Else Convert(DateTime2, Slutdato, 105) End) >= Convert(Date, GetDate()))

Kia: /* Add users to groups */

2022-09-30T12:02:42Z

Add users to groups

← Older revision		Revision as of 12:02, 30 September 2022
Line 40:		Line 40:
	If you only want users with active groups use this extra SQL sentence		If you only want users with active groups use this extra SQL sentence

	And ((Select Case When IsNull(Slutdato, <nowiki>''</nowiki>) = <nowiki>''</nowiki> Then GetDate() + 100 Else Convert(DateTime2, Slutdato, 105) End) >= Convert(Date, GetDate()))		And ((Select Case When IsNull(Slutdato, <nowiki>''</nowiki>) = <nowiki>''</nowiki> Then GetDate() + 100 Else Convert(DateTime2, Slutdato, 105) End) >= Convert(Date, GetDate()))

	[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]		[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]

Kia: /* Add users to groups */

2022-09-30T12:02:31Z

Add users to groups

← Older revision		Revision as of 12:02, 30 September 2022
Line 37:		Line 37:
	===Add users to groups===		===Add users to groups===
	This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.		This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.

			If you only want users with active groups use this extra SQL sentence

			And ((Select Case When IsNull(Slutdato, <nowiki>''</nowiki>) = <nowiki>''</nowiki> Then GetDate() + 100 Else Convert(DateTime2, Slutdato, 105) End) >= Convert(Date, GetDate()))
	[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]		[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]

Phk at 07:21, 25 January 2019

2019-01-25T07:21:41Z

← Older revision		Revision as of 07:21, 25 January 2019
Line 1:		Line 1:
	Custom SQL Commands ~~are~~ a feature for executing customized SQL at specific ~~moments~~ in various background jobs. ~~This moment~~ depends on the job you attach the SQL command to.		Custom SQL Commands is a feature for executing customized SQL at specific times in various background jobs. The time depends on the job you attach the SQL command to.

	This feature is found ~~here~~: Configurator -> Settings -> Custom SQL Commands		This feature is found at: Configurator -> Settings -> Custom SQL Commands
	[[File:Custom SQL commands.jpg\|none\|thumb\|556x556px]]		[[File:Custom SQL commands.jpg\|none\|thumb\|556x556px]]

	== Program ==		==Program==
	~~This is a~~ list of UMS programs that supports Custom SQL commands. The list is only filed with programs that ~~are licensed~~.		The list of UMS programs that supports Custom SQL commands. The list is only filed with programs that you have a license for.

	=== Show commands after ~~the~~ addon file has run ===		===Show commands after addon file has been run===
	Some of the programs ~~has~~ a custom file that it can run instead of the one supplied by UMS.		Some of the programs have a custom file that it can run instead of the one supplied by UMS.

	If you do not have a custom file then ignore this chekbox		If you do not have a custom file then ignore this chekbox

	=== Show commands after <Program name> has run ===		===Show commands after <Program name> has run===
	This allows you to run custom SQL commands after the specific program has finished running. This could be a program like '''SLI'''.		This allows you to run custom SQL commands after the specific program has finished running. This could be a program like '''SLI'''.

	If this is not checked the custom SQL commands will before the program starts.		If this is not checked the custom SQL commands will run before the program starts.

	==Jobs==		==Jobs==
	The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents ~~require~~ no license)		The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents requires no license)

	==[[GetStudents]]==		==[[GetStudents]]==
Line 28:		Line 28:

	====Priority====		====Priority====
	This control in which order commands should run.		This control in which order commands should run. (1 is first)

	====SQL command====		====SQL command====
Line 71:		Line 71:
	[[SLI]]		[[SLI]]

	== FAQ ==		==FAQ==
	If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.		If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.

Kia: /* GetStudents */

2019-01-24T13:55:06Z

GetStudents

@@ Line 3: / Line 3: @@
 This feature is found here: Configurator -> Settings -> Custom SQL Commands
 [[File:Custom SQL commands.jpg|none|thumb|556x556px]]
-If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.
 ==Jobs==
@@ Line 32: / Line 44: @@
 ====GetStudents====
 All fields under this setting are text fields.
 [[GetTimetable]]
@@ Line 56: / Line 70: @@
 [[SLI]]

Kia at 12:56, 24 January 2019

2019-01-24T12:56:11Z

← Older revision		Revision as of 12:56, 24 January 2019
Line 5:		Line 5:
	If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.		If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.

	== Jobs ==		==Jobs==
	The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)		The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)

	== [[GetStudents]] ==		==[[GetStudents]]==
	Always use the table '''ImportFromDB''' instead of the Students table when doing these SQL commands.		Always use the table '''ImportFromDB''' instead of the Students table when doing these SQL commands.
	[[File:Custom SQL commands GetStudents.jpg\|none\|thumb\|725x725px]]		[[File:Custom SQL commands GetStudents.jpg\|none\|thumb\|725x725px]]

	=== Description ===		====Description====
	Enter a name.		Enter a name.

	=== Priority ===		====Priority====
	This control in which order commands should run.		This control in which order commands should run.

	=== SQL command ===		====SQL command====
	Enter the SQL command UMS will run.		Enter the SQL command UMS will run.

	You can create a Store Procedure and run that instead use the command "'''Exec''' '''<Stored Procedure Name>'''"		You can create a Store Procedure and run that instead use the command "'''Exec''' '''<Stored Procedure Name>'''"

	=== Add users to groups ===		===Add users to groups===
	This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.		This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.
	[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]		[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]

	=== SQL Command ===		====SQL Command====
	Only write the part that comes after the SQL Where sentence and not the whole SQL sentence.		Only write the part that comes after the SQL Where sentence and not the whole SQL sentence.

	=== GetStudents ===		====GetStudents====
	All fields under this setting are text fields.		All fields under this setting are text fields.

Kia at 12:55, 24 January 2019

2019-01-24T12:55:35Z

← Older revision		Revision as of 12:55, 24 January 2019
Line 2:		Line 2:

	This feature is found here: Configurator -> Settings -> Custom SQL Commands		This feature is found here: Configurator -> Settings -> Custom SQL Commands
			[[File:Custom SQL commands.jpg\|none\|thumb\|556x556px]]
			If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.

			== Jobs ==
			The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)

			== [[GetStudents]] ==
			Always use the table '''ImportFromDB''' instead of the Students table when doing these SQL commands.
			[[File:Custom SQL commands GetStudents.jpg\|none\|thumb\|725x725px]]

			=== Description ===
			Enter a name.

			=== Priority ===
			This control in which order commands should run.

			=== SQL command ===
			Enter the SQL command UMS will run.

	~~If you ever want to~~ use the ~~UNILOGIN column, you~~'~~ll need to run it after SLI - use the checkbox to change from before to after.~~		You can create a Store Procedure and run that instead use the command "'''Exec''' '''<Stored Procedure Name>'''"

	~~<br />~~		=== Add users to groups ===
			This option allows you to create new groups in UMS. These groups will be handled like any other group coming from the administrative system.
			[[File:Custom SQL commands GetStudents Add users to groups.jpg\|none\|thumb\|725x725px]]

	==~~Jobs~~==		=== SQL Command ===
	~~The following is a list of all programs you can attach Custom~~ SQL ~~commands to. Note that you will only see~~ the ~~programs you have licenses for~~. ~~(GetStudents require no license)~~		Only write the part that comes after the SQL Where sentence and not the whole SQL sentence.

	[[GetStudents]]		=== GetStudents ===
			All fields under this setting are text fields.

	[[GetTimetable]]		[[GetTimetable]]

Khm at 08:57, 16 January 2019

2019-01-16T08:57:48Z

← Older revision		Revision as of 08:57, 16 January 2019
Line 1:		Line 1:
	Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.		Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.

	This feature is found here: Configurator -> Settings -> Custom SQL Commands<br />		This feature is found here: Configurator -> Settings -> Custom SQL Commands


			If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.

			<br />

	==Jobs==		==Jobs==

Bjs at 09:43, 8 January 2019

2019-01-08T09:43:40Z

← Older revision		Revision as of 09:43, 8 January 2019
Line 1:		Line 1:
	Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.		Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.

	<br />		This feature is found here: Configurator -> Settings -> Custom SQL Commands<br />

	==Jobs==		==Jobs==

Bjs at 09:42, 8 January 2019

2019-01-08T09:42:11Z

← Older revision		Revision as of 09:42, 8 January 2019
Line 4:		Line 4:

	==Jobs==		==Jobs==
	The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents ~~is always available~~)		The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)

	[[GetStudents]]		[[GetStudents]]