make chronid variable dynamic

Jonathan K Nelson · Jonathan K Nelson · commit 2ea4742ed099 · 2020-11-23T15:50:32.000-05:00
diff --git a/function/da/chronologybyid.sql b/function/da/chronologybyid.sql
@@ -37,7 +37,7 @@ AS $function$
   LEFT JOIN ndb.chroncontroltypes AS ccrt ON ccr.chroncontroltypeid = ccrt.chroncontroltypeid
   LEFT JOIN ndb.datasets AS ds ON  ds.collectionunitid = chr.collectionunitid
   LEFT JOIN ndb.datasettypes AS dst ON dst.datasettypeid = ds.datasettypeid
-  WHERE chr.chronologyid = 123
+  WHERE chr.chronologyid = _chronid
   GROUP BY chr.isdefault,
         chr.chronologyname,
         aty.agetype,
