210 Standardsuche findet nicht » Historie » Version 18
[X] Daniel S, 30.12.2022 10:42
1 | 18 | [X] Daniel S | h1. F2 Suche Standardsuche findet nichts |
---|---|---|---|
2 | 1 | [X] Daniel S | |
3 | Schlüsselworte neu generieren |
||
4 | |||
5 | <pre><code class="sql"> |
||
6 | 16 | [S] Dominik G | ALTER TABLE recnokeyword DISABLE TRIGGER ALL; |
7 | 1 | [X] Daniel S | |
8 | 14 | [S] Jens A | ALTER USER syncro; |
9 | 17 | [S] Dominik G | Im pgAdmin ausführen, damit nicht alles als eine Transaktion/Statement angesehen wird und nacheinander abläuft. |
10 | 8 | [X] Daniel S | |
11 | /* |
||
12 | 1 | [X] Daniel S | DELETE FROM recnokeyword |
13 | WHERE r_tablename IN ('art', 'adk', 'auftg', 'ldsdok', 'belkopf', 'eingrechdokument', 'anl') |
||
14 | AND r_descr = 'keywordsearch' AND r_kategorie = 'internal system usage'; |
||
15 | 8 | [X] Daniel S | */ |
16 | 1 | [X] Daniel S | |
17 | 9 | [X] Daniel S | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(art) FROM art) AS a; |
18 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(adk) FROM adk) AS a; |
||
19 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(auftg) FROM auftg) AS a; |
||
20 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(ldsdok) FROM ldsdok) AS a; |
||
21 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(belkopf) FROM belkopf) AS a; |
||
22 | 7 | [X] Daniel S | -- ER-Kopf und -Position haben r_tablename='eingrechdokument' |
23 | 9 | [X] Daniel S | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(eingrechdokument.*) FROM eingrechdokument) AS a; |
24 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(belegpos.*) FROM belegpos) AS a; |
||
25 | SELECT count(1) FROM (SELECT TSystem.kws_create_keywords(anl) FROM anl) AS a; |
||
26 | 6 | [X] Daniel S | |
27 | 1 | [X] Daniel S | ALTER TABLE recnokeyword ENABLE TRIGGER ALL; |
28 | 17 | [S] Dominik G | |
29 | |||
30 | /* -- (DG) Wozu ist das? Teil steht hier ohne Kommentar. |
||
31 | CREATE TRIGGER recnokeyword__b_iu |
||
32 | BEFORE INSERT OR UPDATE |
||
33 | ON public.recnokeyword |
||
34 | FOR EACH ROW |
||
35 | WHEN (("current_user"() <> ALL (ARRAY['ELO'::name, 'syncro'::name]))) |
||
36 | EXECUTE PROCEDURE public.recnokeyword__b_iu(); |
||
37 | */ |
||
38 | 4 | [S] Philipp K | </code></pre> |
39 | 5 | [X] Daniel S | |
40 | 1 | [X] Daniel S | Überprüfen ob die Keywordserch eingestellt ist |
41 | |||
42 | * SuperAdmin -> Notizen anklicken -> im Reiter Eigenschaften schauen > #11830 Screenshot unten |