SuperX - Benutzerbeiträge [de]

Aenderungen: edustore sos unload hisinone pg.xml

2018-09-20T12:57:21Z

Durst: /* Vorläufige Studierende */

==Vorläufige Studierende==
<pre>insert into superx_sos(id, mtknr_ldsg,person_id,person_birthdate,person_birthcity,person_k_gender_id)
SELECT DISTINCT S.id,
S.registrationnumber,
S.person_id,
P.birthdate ,
substring(P.birthcity from 1 for 255),
P.k_gender_id
from student S, person P
where P.id=S.person_id
and S.registrationnumber is not null
${STUDENT_FILTER}
and '${SOS_UNL_ANON}' != 'true'
and ((S.updated_at > '${stu_updated_at}') OR (S.updated_at IS NULL AND '${stu_updated_at}' = '1900-01-01'))
--keine vorläufigen Studierenden #118453
--nur Rolle "Student" (hiskey_id=5)
and 0<(select count(*) from orgrole O, role R
where R.id=O.role_id
and S.person_id=O.person_id
and R.hiskey_id in (5<strong>,6,8</strong>));
-- APF 09.05.2018 inc. vorl. Studierende
--Promovierende 81
--Gasthörer 8
</pre>

Wir wollen vorläufige Studierende und Gasthöher mitladen, daher:

<pre>and R.hiskey_id in (5,6,8));</pre>

{|
|-
||'''ID'''
||'''Beschreibung'''
|-
||5
||Student
|-
||6
||vorläufiger Student
|-
||8
||Gasthöhrer
|-
||81
||Promovierender
|}

Aenderungen: edustore sos unload hisinone pg.xml

2018-09-20T12:54:05Z

Durst:

==Vorläufige Studierende==
<pre>insert into superx_sos(id, mtknr_ldsg,person_id,person_birthdate,person_birthcity,person_k_gender_id)
SELECT DISTINCT S.id,
S.registrationnumber,
S.person_id,
P.birthdate ,
substring(P.birthcity from 1 for 255),
P.k_gender_id
from student S, person P
where P.id=S.person_id
and S.registrationnumber is not null
${STUDENT_FILTER}
and '${SOS_UNL_ANON}' != 'true'
and ((S.updated_at > '${stu_updated_at}') OR (S.updated_at IS NULL AND '${stu_updated_at}' = '1900-01-01'))
--keine vorläufigen Studierenden #118453
--nur Rolle "Student" (hiskey_id=5)
and 0<(select count(*) from orgrole O, role R
where R.id=O.role_id
and S.person_id=O.person_id
and R.hiskey_id in (5,6,8));
-- APF 09.05.2018 inc. vorl. Studierende
--Promovierende 81
--Gasthörer 8
</pre>

Wir wollen vorläufige Studierende und Gasthöher mitladen, daher:

<pre>and R.hiskey_id in (5,6,8));</pre>

{|
|-
||'''ID'''
||'''Beschreibung'''
|-
||5
||Student
|-
||6
||vorläufiger Student
|-
||8
||Gasthöhrer
|-
||81
||Promovierender
|}

Aenderungen: edustore sos unload hisinone pg.xml

2018-09-20T12:39:13Z

Durst: /* Keine Zusammenfassung */

<pre>insert into superx_sos(id, mtknr_ldsg,person_id,person_birthdate,person_birthcity,person_k_gender_id)
SELECT DISTINCT S.id,
S.registrationnumber,
S.person_id,
P.birthdate ,
substring(P.birthcity from 1 for 255),
P.k_gender_id
from student S, person P
where P.id=S.person_id
and S.registrationnumber is not null
${STUDENT_FILTER}
and '${SOS_UNL_ANON}' != 'true'
and ((S.updated_at > '${stu_updated_at}') OR (S.updated_at IS NULL AND '${stu_updated_at}' = '1900-01-01'))
--keine vorläufigen Studierenden #118453
--nur Rolle "Student" (hiskey_id=5)
and 0<(select count(*) from orgrole O, role R
where R.id=O.role_id
and S.person_id=O.person_id
and R.hiskey_id in (5,6,8));
-- APF 09.05.2018 inc. vorl. Studierende
--Promovierende 81
--Gasthörer 8
</pre>

Wir wollen vorläufige Studierende und Gasthöher mitladen, daher:

<pre>and R.hiskey_id in (5,6,8));</pre>

{|
|-
||'''ID'''
||'''Beschreibung'''
|-
||5
||Student
|-
||6
||vorläufiger Student
|-
||8
||Gasthöhrer
|-
||81
||Promovierender
|}

Aenderungen: edustore sos unload hisinone pg.xml

2018-09-20T12:36:31Z

Durst:

Aenderungen: edustore sos unload hisinone pg.xml

2018-09-20T12:33:44Z

Durst: Die Seite wurde neu angelegt: „<pre> insert into superx_sos(id, mtknr_ldsg,person_id,person_birthdate,person_birthcity,person_k_gender_id) SELECT DISTINCT S.id, S.registrationnumber, S.pers…“

<pre>
insert into superx_sos(id, mtknr_ldsg,person_id,person_birthdate,person_birthcity,person_k_gender_id)
SELECT DISTINCT S.id,
S.registrationnumber,
S.person_id,
P.birthdate ,
substring(P.birthcity from 1 for 255),
P.k_gender_id
from student S, person P
where P.id=S.person_id
and S.registrationnumber is not null
${STUDENT_FILTER}
and '${SOS_UNL_ANON}' != 'true'
and ((S.updated_at > '${stu_updated_at}') OR (S.updated_at IS NULL AND '${stu_updated_at}' = '1900-01-01'))
--keine vorläufigen Studierenden #118453
--nur Rolle "Student" (hiskey_id=5)
and 0<(select count(*) from orgrole O, role R
where R.id=O.role_id
and S.person_id=O.person_id
and R.hiskey_id in (5,6,8));
-- APF 09.05.2018 inc. vorl. Studierende
--Promovierende 81
--Gasthörer 8
</pre>