PDCI Index for GRIN-Global
From: "Rojas, Edwin (CIP)" E.ROJAS@CGIAR.ORG Subject: PDCI Index for GRIN-Global Date: 20 July 2021 at 19:06:52 GMT+2
To share some steps to add PDCI Index to GG.
Step 1: Create a Crop Trait for PDCI for each crop (Curator Tool and Wizard Crop Trait) Step 2: Create a SQL function to calculate PDCI (TSQL_PDCI.txt) Step 3: Update PDCI Crop Trait with a SQL script (TSQL_Merge.txt) Step 4: Create a SQL view by accession with the passport and PDCI column Step 5: Add PDCI Crop Trait to your reports like PowerBI
Please Matija try to consider add support to PDCI by accession in GG-CE to facilitate improving data curation.
Many thanks, Edwin