210 Standardsuche findet nicht » Historie » Version 7
[X] Daniel S, 07.03.2019 20:22
1 | 1 | [X] Daniel S | h1. Standardsuche findet nicht |
---|---|---|---|
2 | |||
3 | Schlüsselworte neu generieren |
||
4 | |||
5 | <pre><code class="sql"> |
||
6 | 2 | [S] Dominik G | ALTER TABLE recnokeyword DISABLE TRIGGER ALL; |
7 | |||
8 | 3 | [S] Dominik G | DELETE FROM recnokeyword |
9 | WHERE r_tablename IN ('art', 'adk', 'auftg', 'ldsdok', 'belkopf', 'eingrechdokument', 'anl') |
||
10 | AND r_descr = 'keywordsearch' AND r_kategorie = 'internal system usage'; |
||
11 | 2 | [S] Dominik G | |
12 | 7 | [X] Daniel S | SELECT count(1) FROM TSystem.kws_create_keywords(art) FROM art; |
13 | SELECT count(1) FROM TSystem.kws_create_keywords(adk) FROM adk; |
||
14 | SELECT count(1) FROM TSystem.kws_create_keywords(auftg) FROM auftg; |
||
15 | SELECT count(1) FROM TSystem.kws_create_keywords(ldsdok) FROM ldsdok; |
||
16 | SELECT count(1) FROM TSystem.kws_create_keywords(belkopf) FROM belkopf; |
||
17 | 2 | [S] Dominik G | -- ER-Kopf und -Position haben r_tablename='eingrechdokument' |
18 | 7 | [X] Daniel S | SELECT count(1) FROM TSystem.kws_create_keywords(eingrechdokument.*) FROM eingrechdokument; |
19 | SELECT count(1) FROM TSystem.kws_create_keywords(belegpos.*) FROM belegpos; |
||
20 | SELECT count(1) FROM TSystem.kws_create_keywords(anl) FROM anl; |
||
21 | 2 | [S] Dominik G | |
22 | ALTER TABLE recnokeyword ENABLE TRIGGER ALL; |
||
23 | 6 | [X] Daniel S | |
24 | CREATE TRIGGER recnokeyword__b_iu |
||
25 | BEFORE INSERT OR UPDATE |
||
26 | ON public.recnokeyword |
||
27 | FOR EACH ROW |
||
28 | WHEN (("current_user"() <> ALL (ARRAY['ELO'::name, 'syncro'::name]))) |
||
29 | EXECUTE PROCEDURE public.recnokeyword__b_iu(); |
||
30 | 1 | [X] Daniel S | </code></pre> |
31 | 4 | [S] Philipp K | |
32 | Überprüfen ob die Keywordserch eingestellt ist |
||
33 | |||
34 | 5 | [X] Daniel S | * SuperAdmin -> Notizen anklicken -> im Reiter Eigenschaften schauen > #11830 Screenshot unten |