From 17b3705bf12f7d8e6fe4d5f33274c11a69b7ad66 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Tue, 6 Jun 2023 14:43:29 +0300
Subject: Replace citations to source from Datasets instead of InfoFiles

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 examples/dump-dataset-metadata.scm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm
index bf6a272..883672c 100755
--- a/examples/dump-dataset-metadata.scm
+++ b/examples/dump-dataset-metadata.scm
@@ -211,7 +211,7 @@
           (regexp-substitute/global
            #f "^[Nn]one$"
            (field
-            ("CAST(CONVERT(BINARY CONVERT(IFNULL(IF(InfoFiles.Citation = 'None' OR InfoFiles.Citation = '' OR InfoFiles.Citation IS NULL, Datasets.Citation, InfoFiles.Citation), '') USING latin1) USING utf8) AS VARCHAR(1500))"
+            ("CAST(CONVERT(BINARY CONVERT(Datasets.Citation USING latin1) USING utf8) AS VARCHAR(1500))"
              Citation))
            "")))
     (set gn:dataSourceAcknowledgment
-- 
cgit v1.2.3