Difference between revisions of "Search filter and criteria"

From UmsWiki
Jump to: navigation, search
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=== '''Search filter and criteria''' ===
+
Please note that some LMS integrations may not use 'sites' but rooms, cohorts, drives, etc.
This will enable you to concatenate sites that would have been created as to or more sites to be created as one site.
 
  
'''“Remarks”'''
+
== Search filter and criteria - Activity ==
 +
This will enable you to link sites that would have been created as two or more sites. Thus, they will be created as one site.
  
 +
=== Remarks ===
 
This is just for description purposes.  
 
This is just for description purposes.  
  
'''“Filter”'''
+
=== Filter ===
 +
This is the SQL like filter (regular expression). If an activity matches, it will be subject to the settings in 'Semester roll'.
  
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
+
=== Semester roll ===
 
 
'''“Semester roll”'''
 
 
 
'''“Use replace string with empty”'''
 
  
 +
==== Use replace string with empty ====
 
This will replace a section of the site with an empty string.
 
This will replace a section of the site with an empty string.
  
'''“Start index”'''
+
==== Start index ====
 
+
Determines where in the string it should start to remove.
Determine where to start in string to remove.
 
 
 
'''“Length”'''
 
 
 
How many characters will be removed from the string.
 
 
 
“'''Add activity short description to node ID'''“
 
 
 
This will add the field Kort_Betegnelse (Short Description) from the students table to the node id.
 
 
 
Node id is the URL.
 
 
 
==== '''Examples''' ====
 
If you have three activities named English1, English2, English3 and you only want one SharePoint site.
 
 
 
Set the settings as shown below
 
[[File:Office365filterexample.png|none|thumb]]
 
 
 
This filter ensures that it is only applied to activities that matches this SQL sentence.  
 
 
 
'''“Course Sites”'''
 
 
 
Course URL’s will always be created as “activity_course”.
 
 
 
'''“Do not create”'''
 
 
 
It will not create any sites based on courses.
 
 
 
'''“LMS has to be checked”'''
 
 
 
The field Skolefag_LMS in the students table has to be “True”. (Look in the documentation for the specific administrative system to see how this is set)
 
 
 
'''“Based on template filter”'''
 
 
 
Create sites based on a filter that is specified per template.
 
[[File:Office365filters.png|none|thumb]]
 
 
 
'''“All”'''
 
 
 
Create all sites.
 
 
 
'''Title'''
 
  
Title of the site. Changing this after a site has been created will cause it to be updated.
+
==== Length ====
 +
How many characters that will be removed from the string.
  
'''Description'''
+
==== Add activity short description to node ID ====
 +
This will add the field 'Kort_Betegnelse' (Short Description) from the students' table to the node ID.[[File:Search filter and criteria (Activity).png|none|thumb|401x401px]]
  
Description of the site. Changing this after a site has been created will cause it to be updated.
+
=== Examples ===
 +
Set the settings as shown below. This will create one site for 'English' levels 1, 2, and 3. The filter 'English[123]' ensures that it is only applied to activities that matches this SQL sentence. [[File:Office365filterexample.png|none|thumb|401x401px]]
  
  ==== '''Search filter and criteria''' ====
+
== Search filter and criteria - Course ==
This will enable you to concatenate sites that would have been created as two or more sites to be created as one site.
+
This will enable you to link sites that would have been created as two or more sites. Thus, they will be created as one site. A course is always a child to an activity and therefore cannot exist without an activity.
[[File:Office365filter.png|none|thumb]]
 
 
 
'''“Remarks”'''
 
  
 +
=== Remarks ===
 
This is just for description purposes.  
 
This is just for description purposes.  
  
'''“Course Filter”'''
+
=== Course Filter ===
  
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll.
+
==== Filter ====
 
+
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below.
'''“Semester roll”'''
 
 
 
'''“Use replace string with empty”'''
 
  
 +
==== Use replace string with empty ====
 
This will replace a section of the site with an empty string.
 
This will replace a section of the site with an empty string.
  
'''“Start index”'''
+
==== Start index ====
 
+
Determines where in the string it should start to remove.
Determine where to start in string to remove.
 
  
'''“Length”'''
+
==== Length ====
 +
How many characters that will be removed from the string.
  
How many characters will be removed from the string.
+
=== Activity Filter ===
  
'''“Activity Filter”'''
+
==== Filter ====
 
+
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below.
The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below in semester roll
 
 
 
'''“Semester roll”'''
 
 
 
'''“Use replace string with empty”'''
 
  
 +
==== Use replace string with empty ====
 
This will replace a section of the site with an empty string.
 
This will replace a section of the site with an empty string.
  
'''“Start index”'''
+
==== Start index ====
 
+
Determines where in the string it should start to remove.
Determine where to start in string to remove.
 
  
'''“Length”'''
+
==== Length ====
 +
How many characters that will be removed from the string.[[File:Search filter and criteria (Course).png|none|thumb|421x421px]]
 +
=== Example ===
 +
This is an example for if you have an activity with multiple courses attached and you only want one site. Set the settings as shown below.
  
How many characters will be removed from the string.
+
This will create one site for '9a English' for levels 1, 2, and 3. The filters 'English[123]' and '9a' ensure that it is only applied to courses that matches this SQL sentence.[[File:Search filter and criteria (Course) Example.png|none|thumb|421x421px]]

Latest revision as of 06:28, 15 June 2018

Please note that some LMS integrations may not use 'sites' but rooms, cohorts, drives, etc.

Search filter and criteria - Activity

This will enable you to link sites that would have been created as two or more sites. Thus, they will be created as one site.

Remarks

This is just for description purposes.

Filter

This is the SQL like filter (regular expression). If an activity matches, it will be subject to the settings in 'Semester roll'.

Semester roll

Use replace string with empty

This will replace a section of the site with an empty string.

Start index

Determines where in the string it should start to remove.

Length

How many characters that will be removed from the string.

Add activity short description to node ID

This will add the field 'Kort_Betegnelse' (Short Description) from the students' table to the node ID.

Search filter and criteria (Activity).png

Examples

Set the settings as shown below. This will create one site for 'English' levels 1, 2, and 3. The filter 'English[123]' ensures that it is only applied to activities that matches this SQL sentence.

Office365filterexample.png

Search filter and criteria - Course

This will enable you to link sites that would have been created as two or more sites. Thus, they will be created as one site. A course is always a child to an activity and therefore cannot exist without an activity.

Remarks

This is just for description purposes.

Course Filter

Filter

The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below.

Use replace string with empty

This will replace a section of the site with an empty string.

Start index

Determines where in the string it should start to remove.

Length

How many characters that will be removed from the string.

Activity Filter

Filter

The SQL like filter (regular expression). If an activity matches, it will be subject to the settings below.

Use replace string with empty

This will replace a section of the site with an empty string.

Start index

Determines where in the string it should start to remove.

Length

How many characters that will be removed from the string.

Search filter and criteria (Course).png

Example

This is an example for if you have an activity with multiple courses attached and you only want one site. Set the settings as shown below.

This will create one site for '9a English' for levels 1, 2, and 3. The filters 'English[123]' and '9a' ensure that it is only applied to courses that matches this SQL sentence.

Search filter and criteria (Course) Example.png