aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-06-06 14:43:29 +0300
committerBonfaceKilz2023-06-12 19:06:36 +0300
commit17b3705bf12f7d8e6fe4d5f33274c11a69b7ad66 (patch)
tree91b953270dbe2ba37e9a2af29c5daadffbf2fb46
parentcee11c564eeeed78e19cf1d8a9387fcdb5caf1f6 (diff)
downloadgn-transform-databases-17b3705bf12f7d8e6fe4d5f33274c11a69b7ad66.tar.gz
Replace citations to source from Datasets instead of InfoFiles
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rwxr-xr-xexamples/dump-dataset-metadata.scm2
1 files changed, 1 insertions, 1 deletions
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