72 lines
2.5 KiB
Plaintext
72 lines
2.5 KiB
Plaintext
Dokumentarten:
|
|
SELECT dokuart AS Dokumentart, kue_dokuart AS Kürzel FROM arten_dokumente WHERE dokument_typ = 'd' AND kue_dokuart NOT LIKE '$%' ORDER BY dokuart
|
|
|
|
|
|
Aktenarten:
|
|
SELECT dokuart AS Aktenart, kue_dokuart AS Kürzel FROM arten_dokumente WHERE doku-ment_typ = 'a' AND kue_dokuart NOT LIKE '$%' ORDER BY dokuart
|
|
|
|
|
|
Wertemengen:
|
|
SELECT predef_val_text from doc_field_val_names ORDER BY predef_val_text
|
|
|
|
|
|
Werte in den Wertemengen:
|
|
SELECT dfvn.predef_val_text AS Wertemenge, dfv.value_char_allowed AS ErlaubterWert
|
|
FROM doc_field_val_names dfvn
|
|
JOIN doc_field_values dfv ON dfvn.predef_val_id = dfv.predef_value_id ORDER BY dfvn.predef_val_text, dfv.value_char_allowed
|
|
|
|
|
|
Erweiterte Eigenschaften:
|
|
SELECT repository_text AS "Erweiterte Eigenschaft", doc_field_nr_pref AS "Dok_dat_feld", da-ta_type AS "Typ", data_length AS "Länge" FROM field_repository WHERE repository_text NOT LIKE '$%' AND repository_text <> 'Logging-Typ' AND repository_text <> 'Logging-Datum';
|
|
|
|
|
|
Gruppen:
|
|
SELECT benutzergruppe AS d3Gruppe FROM benutzergruppen ORDER BY benutzergruppe
|
|
|
|
|
|
Berechtigungen:
|
|
SELECT roll_text AS Berechtigungsprofile FROM doc_roll_header ORDER BY roll_text
|
|
|
|
|
|
Rendition Regeln:
|
|
SELECT
|
|
dch.class_text AS Dokumentklasse,
|
|
tr.doc_extension AS Dateierweiterung,
|
|
CASE WHEN tr.tiff_event = 'N' THEN 'Neuer Version'
|
|
WHEN tr.tiff_event = 'I' THEN 'Neuimport'
|
|
WHEN tr.tiff_event = 'F' THEN 'Transfer in Freigabe'
|
|
WHEN tr.tiff_event = 'P' THEN 'Transfer in Prüfung'
|
|
WHEN tr.tiff_event = 'A' THEN 'Transfer in Archiv'
|
|
END AS Ereignis,
|
|
CASE WHEN tr.tiff_option = '1' THEN 'TIF'
|
|
WHEN tr.tiff_option = '2' THEN 'PDF'
|
|
ELSE '-'
|
|
END AS Zielformat,
|
|
CASE WHEN tr.ocr_option = '1' THEN 'Ja' ELSE 'Nein' END AS Verschlagwortung
|
|
FROM tiff_rules tr
|
|
JOIN doc_classes_header dch ON dch.class_shortcut = tr.class_shortcut ORDER BY dch.class_text
|
|
|
|
|
|
Abfrage um Regeln abzufragen, die nicht einer Dokumentklasse angehören:
|
|
SELECT
|
|
tr.class_shortcut AS Dokumentklasse,
|
|
tr.doc_extension AS Dateierweiterung,
|
|
CASE WHEN tr.tiff_event = 'N' THEN 'Neuer Version'
|
|
WHEN tr.tiff_event = 'I' THEN 'Neuimport'
|
|
WHEN tr.tiff_event = 'F' THEN 'Transfer in Freigabe'
|
|
WHEN tr.tiff_event = 'P' THEN 'Transfer in Prüfung'
|
|
WHEN tr.tiff_event = 'A' THEN 'Transfer in Archiv'
|
|
END AS Ereignis,
|
|
CASE WHEN tr.tiff_option = '1' THEN 'TIF'
|
|
WHEN tr.tiff_option = '2' THEN 'PDF'
|
|
ELSE '-'
|
|
END AS Zielformat,
|
|
CASE WHEN tr.ocr_option = '1' THEN 'Ja' ELSE 'Nein' END AS Verschlagwortung
|
|
FROM tiff_rules tr
|
|
WHERE tr.class_shortcut IS NULL
|
|
ORDER BY tr.class_shortcut
|
|
|
|
|
|
|
|
|