610 ELO-DMS ankoppeln » Historie » Version 1
[X] Daniel S, 30.04.2018 09:39
| 1 | 1 | [X] Daniel S | h1. ELO |
|---|---|---|---|
| 2 | |||
| 3 | |||
| 4 | h2. Funktionen und Bsp-Aufrufe |
||
| 5 | |||
| 6 | * SELECT * FROM TDMS.External_DMS__get_Documents WHERE is_updated_or_new; |
||
| 7 | * TDMS.External_DMS__get_Keywords(pd_id) |
||
| 8 | * TDMS.External_DMS__set_ID(pd_id, external_id) |
||
| 9 | * TDMS.External_DMS__reset_Updated(pd_id) |
||
| 10 | |||
| 11 | Achtung: Zugriff des ELO nur über DMS-User "ELO". |
||
| 12 | Mindestens TDMS.External_DMS__set_ID und TDMS.External_DMS__reset_Updated müssen mit DMS-User ausgeführt werden. |
||
| 13 | |||
| 14 | |||
| 15 | * SELECT * FROM TDMS.External_DMS__get_Documents; |
||
| 16 | * SELECT * FROM TDMS.External_DMS__get_Documents WHERE is_updated_or_new; |
||
| 17 | * SELECT * FROM TDMS.External_DMS__get_Documents WHERE is_updated_or_new AND pd_external_dms_id IS NOT NULL; |
||
| 18 | * SELECT * FROM TDMS.External_DMS__get_Documents WHERE pd_external_dms_id = "external_id"; |
||
| 19 | * SELECT * FROM TDMS.External_DMS__get_Keywords(pd_id); |
||
| 20 | * SELECT TDMS.External_DMS__set_ID(pd_id, "external_id"); |
||
| 21 | * SELECT TDMS.External_DMS__reset_Updated(pd_id); |
||
| 22 | * SELECT TDMS.External_DMS__get_RemoteFilename(pd_id, True); |