*Deprecated* See https://wiki.duraspace.org/display/VIVODOC/All+Documentation for current documentation

Note that these are CONSTRUCT queries designed to create a small Jena model for export as a whole after a series of queries has been run.  The PERSON_URI variable is substituted by VIVO at runtime.

grantAwardedBy.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

CONSTRUCT {
     ?awardingOrganization rdfs:label ?label 
} WHERE {
    {
      {PERSON_URI core:relatedBy ?investigatorRole .
       ?investigatorRole a core:PrincipalInvestigatorRole
      }
        union
      {PERSON_URI core:relatedBy ?investigatorRole .
       ?investigatorRole a core:CoPrincipalInvestigatorRole
      }   
     }
     
     ?investigatorRole core:relatedBy ?grant .
     ?grant a core:Grant .
     ?grant core:assignedBy ?awardingOrganization .
     ?awardingOrganization a foaf:Organization .
     ?awardingOrganization rdfs:label ?label 
}
grants.sparql
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

CONSTRUCT {
     ?grant ?property ?object .
     ?investigatorRole core:relatedBy ?grant .
} WHERE {
     {
       { PERSON_URI core:relatedBy ?investigatorRole .
         ?investigatorRole a core:PrincipalInvestigatorRole
       }
         union
       { PERSON_URI core:relatedBy ?investigatorRole .
         ?investigatorRole a core:CoPrincipalInvestigatorRole
       }   
     }
     
     ?investigatorRole core:relatedBy ?grant .
     ?grant a core:Grant .
     ?grant ?property ?object 
}
  • No labels