You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
31 lines
2.6 KiB
31 lines
2.6 KiB
delete from macro_feld_wert where macro=47060; |
|
|
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,10,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Semester'' order by 2',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,10,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Geschlecht'' order by 2',1); |
|
|
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,20,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Semester'' order by 2',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,20,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Nationalität'' order by 2',1); |
|
|
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,30,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Hochschule'' order by 2',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,30,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Geschlecht'' order by 2',1); |
|
|
|
|
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,40,'Ansicht in Ergebniszeilen','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Hochschule'' order by 2',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,40,'Ansicht in Ergebnisspalten','<<SQL>> select name,caption from xcube_dimconfig where maskeninfo_id=47030 and caption=''Nationalität'' order by 2',1); |
|
|
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,10,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,20,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,30,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1); |
|
insert into macro_feld_wert (macro, sortnr, feldname, value, active) |
|
values (47060,40,'Kennzahl','<<SQL>> select tid,name from xcube_kennzahl where maskeninfo_id=47030 order by sortnr,name;',1);
|
|
|