From 37a294839a66615e8d6967e06034ae3020caf0e6 Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Fri, 26 May 2023 08:37:29 +0300
Subject: Use a phenotype's abbreviation as it's name

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 examples/dump-phenotype.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/examples/dump-phenotype.scm b/examples/dump-phenotype.scm
index 5f8cd94..0b46a14 100755
--- a/examples/dump-phenotype.scm
+++ b/examples/dump-phenotype.scm
@@ -61,8 +61,8 @@
     (set rdf:type 'gn:phenotype)
     (set gn:name (sanitize-rdf-string
                   (field
-                   ("CAST(CONVERT(BINARY CONVERT(CONCAT(IF(PublishFreeze.Name IS NULL, '', CONCAT(PublishFreeze.Name, '-')), IF(Phenotype.Post_publication_abbreviation IS NULL, IF(Phenotype.Pre_publication_abbreviation IS NULL, Phenotype.Id, Phenotype.Pre_publication_abbreviation), Phenotype.Post_publication_abbreviation)) USING latin1) USING utf8) AS VARCHAR(10000))"
-                    abbrev))))
+                   ("CAST(CONVERT(BINARY CONVERT(IF(Phenotype.Post_publication_abbreviation IS NULL, IF(Phenotype.Pre_publication_abbreviation IS NULL, Phenotype.Id, Phenotype.Pre_publication_abbreviation), Phenotype.Post_publication_abbreviation) USING latin1) USING utf8) AS VARCHAR(100))"
+                    PhenotypeName))))
     ;; There is no row with an empty post-publication description so
     ;; use this field as the main publication description
     (set gn:publicationDescription
-- 
cgit v1.2.3