210 Standardsuche findet nicht » Historie » Version 13
[S] Jens A, 10.07.2020 12:01
1 | 12 | [S] Jens A | h1. Standardsuche findet nichts |
---|---|---|---|
2 | 1 | [X] Daniel S | |
3 | Schlüsselworte neu generieren |
||
4 | |||
5 | <pre><code class="sql"> |
||
6 | 8 | [X] Daniel S | --ALTER TABLE recnokeyword DISABLE TRIGGER ALL; |
7 | 1 | [X] Daniel S | |
8 | 8 | [X] Daniel S | USER syncro; |
9 | 13 | [S] Jens A | 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 | 11 | [X] Daniel S | ALTER TABLE recnokeyword ENABLE TRIGGER ALL; |
28 | /* |
||
29 | 6 | [X] Daniel S | CREATE TRIGGER recnokeyword__b_iu |
30 | BEFORE INSERT OR UPDATE |
||
31 | ON public.recnokeyword |
||
32 | 1 | [X] Daniel S | FOR EACH ROW |
33 | WHEN (("current_user"() <> ALL (ARRAY['ELO'::name, 'syncro'::name]))) |
||
34 | 4 | [S] Philipp K | EXECUTE PROCEDURE public.recnokeyword__b_iu(); |
35 | 11 | [X] Daniel S | */ |
36 | 4 | [S] Philipp K | </code></pre> |
37 | 5 | [X] Daniel S | |
38 | 1 | [X] Daniel S | Überprüfen ob die Keywordserch eingestellt ist |
39 | |||
40 | * SuperAdmin -> Notizen anklicken -> im Reiter Eigenschaften schauen > #11830 Screenshot unten |