Wählen Sie einen "Table Input" Step:

 

Der Parameter ist das Semester. Hier der SQL zum Kopieren:

select C.orgunit_lid as fakultaet_nr,
PE.surname as nachname,
PE.firstname as vorname,
S.registrationnumber as mtknr,
C.degree_lid as abschluss_lid,
C.subject_lid as studiengang_lid,
E.date_of_work as abschlussdatum,
N.grade as Gesamtnote,
null::decimal as bewertungabschlussarbeit,
::varchar as titelabschlussarbeit,
::varchar as 	betreuerabschlussarbeit,
DP.studysemester as	anzahlsemester,
::varchar as 	anschrift,
::varchar as 	plz,
::varchar as 	ort,
case when PE.k_gender_id=1 then 'Herr'
when PE.k_gender_id=2 then 'Frau'
else null::varchar(255) end as 		Anrede,
current_date as heute
from
hisinone.unit_studies US,
hisinone.course_of_study C,
hisinone.degree_program_progress DP,
hisinone.degree_program D,
hisinone.period P,
hisinone.student S,
hisinone.person PE,
hisinone.examplan E,
hisinone.term_type T,
hisinone.unit U ,
hisinone.examrelation R
left outer join hisinone.examresult N on (N.examrelation_id=R.id)
where U.id=US.unit_id
and C.lid=US.course_of_study_lid
and E.unit_id=U.id
and E.default_examrelation_id=R.id
and D.id=DP.degree_program_id
and DP.course_of_study_id=C.id
and DP.period_id=P.id
and D.student_id=S.id
and PE.id=S.person_id
and P.term_type_id=E.term_type_id
and P.term_year=E.term_year
and S.person_id=E.person_id
and T.id=E.term_type_id
and U.official_statistics =1 --Hauptprüfung
and (to_number(' ' || E.term_year || T.termnumber,'99999') ) = ${Semester}
order by 1,2,3;