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 --- 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