From 9a7fd35850661916792887f2bb15fec50de317a9 Mon Sep 17 00:00:00 2001
From: Alexander_Kabui
Date: Fri, 7 Jul 2023 19:05:17 +0300
Subject: update issues/linking-genofiles-to-dataset

---
 issues/linking_genotype-files-to-datasets.gmi | 33 ++++++++++++++++++++++++++-
 1 file changed, 32 insertions(+), 1 deletion(-)

diff --git a/issues/linking_genotype-files-to-datasets.gmi b/issues/linking_genotype-files-to-datasets.gmi
index d6fdccb..03a302f 100644
--- a/issues/linking_genotype-files-to-datasets.gmi
+++ b/issues/linking_genotype-files-to-datasets.gmi
@@ -5,7 +5,7 @@
 * assigned: alexm
 * type: debug
 * priority: high
-* status: in progrss
+* status: in progress
 
 ## Notes
 
@@ -14,4 +14,35 @@ A dataset can have multiple groups. In order to fetch all possible sample data f
 As an example example the dataset HC_M2_0606_P is of type Probeset and linked groups for this dataset include (bxd,others) that would translate to these genofiles BXD.geno etc
 
 
+## Species relationship to groups/
+A dataset has got species for example (mouse,human)
+Similary a species can have multiple groups/families
 
+Example-> Species(mouse) ->Families(BXD family, B6D2RI, B6D2F2) -> Genofiles related to this (BXD.geno, B6D2RI.geno, B6D2F2.geno)
+
+* How to fetch Families given a species
+
+```sql
+SELECT InbredSet.Name, InbredSet.FullName
+FROM InbredSet, Species WHERE Species.Name = 'mouse'
+AND InbredSet.SpeciesId = Species.Id GROUP by 
+InbredSet.Name ORDER BY IFNULL(InbredSet.FamilyOrder, 
+InbredSet.FullName) ASC, IFNULL(InbredSet.Family, 
+InbredSet.FullName) ASC, InbredSet.FullName ASC,
+InbredSet.MenuOrderId ASC
+
+```
+
+* Limit you fetch to specified type for Dataset
+Example of types Probeset,Publish
+
+
+```sql
+
+select InbredSet.Name, InbredSet.FullName from InbredSet,Species,
+ProbeFreeze where Species.Name = 'mouse'
+and InbredSet.SpeciesId = Species.Id and
+(ProbeFreeze.InbredSetId = InbredSet.Id)
+group by InbredSet.Name
+order by InbredSet.FullName 
+```
-- 
cgit v1.2.3