From c02d027dbd6476d375821e7dcbe3a719252ca092 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 2 Dec 2022 06:56:46 +0300
Subject: correlations: Fix description

* wqflask/wqflask/correlation/rust_correlation.py: Add
  `Probe_Target_Description` to the description field for "ProbeSet"
  traits.
---
 wqflask/wqflask/correlation/rust_correlation.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'wqflask')

diff --git a/wqflask/wqflask/correlation/rust_correlation.py b/wqflask/wqflask/correlation/rust_correlation.py
index 81c2a416..f1294dfb 100644
--- a/wqflask/wqflask/correlation/rust_correlation.py
+++ b/wqflask/wqflask/correlation/rust_correlation.py
@@ -31,7 +31,8 @@ def query_probes_metadata(dataset, trait_list):
 
             query = """
                     SELECT ProbeSet.Name,ProbeSet.Chr,ProbeSet.Mb,
-                    ProbeSet.Symbol,ProbeSetXRef.mean,ProbeSet.description,
+                    ProbeSet.Symbol,ProbeSetXRef.mean,
+                    CONCAT_WS('; ', ProbeSet.description, ProbeSet.Probe_Target_Description) AS description,
                     ProbeSetXRef.additive,ProbeSetXRef.LRS,Geno.Chr, Geno.Mb
                     FROM ProbeSet INNER JOIN ProbeSetXRef
                     ON ProbeSet.Id=ProbeSetXRef.ProbeSetId
-- 
cgit v1.2.3