resolve keyword search

jknelsonPSU · web-flow · commit 68020ae12832 · 2021-03-08T18:46:23.000-05:00
These commits resolve keyword search issues that were causing Explorer search to hang.
diff --git a/function/ap/explorersearch.sql b/function/ap/explorersearch.sql
@@ -145,7 +145,7 @@ BEGIN
                 cteBaseFrom := cteBaseFrom || '
                     JOIN ndb.samplekeywords k on s.sampleid = k.sampleid';
                 cteBaseWhere := cteBaseWhere || '
-                    AND k.KeywordID = _keywordId';
+                    AND k.keywordid = _keywordid';
               END;
             END IF;
 
@@ -398,7 +398,7 @@ BEGIN
           AND EXISTS (SELECT k.datasetid, k.keywordid
                       FROM   ap.datasetkeywords k
                       WHERE  k.datasetid = ds.datasetid
-                      AND    k.keywordid = ' || _keywordid ' )';
+                      AND    k.keywordid = ' || _keywordid || ' )';
     END IF;
 
     IF _datasettypeid IS NOT NULL THEN
