Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • GGCE Support GGCE Support
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Issues 50
    • Issues 50
    • List
    • Boards
    • Service Desk
    • Milestones
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Create a new issue
  • Issue Boards
Collapse sidebar
  • GGCEGGCE
  • GGCE SupportGGCE Support
  • Issues
  • #100
Closed
Open
Issue created Jul 21, 2021 by matija.obreza@croptrust.org via GitLab Support Bot@support-bot

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

Dear All,

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

TSQL_Merge.txt

TSQL_PDCI.txt

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking