Changes between Version 4 and Version 5 of DespoinaLog/2010/12/09

Timestamp:

2010-12-09T12:35:30+01:00 (14 years ago)

Author:

antonak

Comment:

--

DespoinaLog/2010/12/09

@@ -6 +6 @@
  * create new table biobank from pheno project as follows:
 
-  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate , Description, id from biobank ;
+  mysql> create  table biobank_new select Acronym, Category, Type, Size, !LastUpdate  , Description, id from biobank ;
 
   (only fields that exist in biobank in gcc project)
@@ -12 +12 @@
  * Dump and insert new table in gcc project.
    * $ mysqldump5 -u root -p bbmri_old biobank_new > biobank_new.mysql
- * Edit  biobank_new.mysql and replace biobank_new (table) with biobank
+ * Edit  biobank_new.mysql and replace biobank_new (table) with biobank
  * 
    * mysql5 -u root -p bbmri < biobank_new.mysql
+
+== select query retrieving records in molgenis form ==
+=== We need data inside INNER JOIN tables ===
+select count(*) as num_rows  FROM Biobank  INNER JOIN 
+
+Panel ON (Biobank.id = Panel.id) INNER JOIN 
+
+!ObservationTarget ON (Biobank.id = !ObservationTarget.id) INNER JOIN 
+
+!ObservationElement ON (Biobank.id = !ObservationElement.id) LEFT JOIN Investigation AS xref_Investigation  ON xref_Investigation.id = !ObservationElement.Investigation LEFT JOIN !OntologyTerm AS xref_ontologyReference  ON xref_ontologyReference.id = !ObservationElement.ontologyReference LEFT JOIN !OntologyTerm AS xref_Species  ON xref_Species.id = Panel.Species LEFT JOIN !OntologyTerm AS xref_PanelType  ON xref_PanelType.id = Panel.!PanelType LEFT JOIN !OntologyTerm AS xref_Category  ON xref_Category.id = Biobank.Category WHERE !ObservationElement.!__Type = 'Biobank'