From 6bd25593d8533f491a268b05ffe986bab1683eca Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Mon, 23 Jun 2025 09:54:46 +0000
Subject: [PATCH] GS-2156
---
lib/db.js | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index 531e5cf..028b5b0 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -40,6 +40,7 @@
getKursTeilnehmer,
getKursTeilnehmerCount,
+ getUdf,
}
/////////////////////////////////////////////////////////////////////////
@@ -311,6 +312,7 @@
WHERE (or2.ref_id = ${ref_id} OR parent_id = ${ref_id})
ORDER BY usr_id
`
+ console.log(q)
const [results] = await pool.query(q)
return results
}
@@ -350,3 +352,12 @@
const [results] = await pool.query(q)
return results
}
+
+/////// UDF ////////////////////////////////////////////////////////////////
+
+async function getUdf() {
+ const pool = await poolP
+ const q = `SELECT field_id, field_name, field_type from ${database}.udf_definition;`
+ const [results] = await pool.query(q)
+ return results
+}
--
Gitblit v1.8.0