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); |