From f5988b60e9fc184fb3a7b1e9cdcfc3a85aafe82b Mon Sep 17 00:00:00 2001
From: zsloan
Date: Thu, 1 Dec 2022 21:36:28 +0000
Subject: Return Chr and Mb separately for phenotype /traits API request

---
 wqflask/wqflask/api/router.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/wqflask/wqflask/api/router.py b/wqflask/wqflask/api/router.py
index bae1d129..1e0c53a7 100644
--- a/wqflask/wqflask/api/router.py
+++ b/wqflask/wqflask/api/router.py
@@ -424,7 +424,7 @@ def fetch_traits(dataset_name, file_format="json"):
                         PublishXRef.`LRS`,
                         PublishXRef.`additive`,
                         PublishXRef.`Locus`,
-                        CONCAT('Chr', Geno.`Chr`, ': ', Geno.`Mb`)
+                        Geno.`Chr`, Geno.`Mb`
                         FROM Species
                             INNER JOIN InbredSet ON InbredSet.`SpeciesId` = Species.`Id`
                             INNER JOIN PublishXRef ON PublishXRef.`InbredSetId` = InbredSet.`Id`
@@ -441,7 +441,7 @@ def fetch_traits(dataset_name, file_format="json"):
                                 PublishXRef.Id"""
 
                 field_list = ["Id", "Authors", "Year", "PubMedID", "Mean",
-                              "LRS", "Additive", "Locus", "Position"]
+                              "LRS", "Additive", "Locus", "Chr", "Mb"]
 
             if 'limit_to' in request.args:
                 limit_number = request.args['limit_to']
-- 
cgit v1.2.3