Outdated
This material pertains to outdated versions of VIVO. Rather than archiving the material, it should be updated to reflect current versions of VIVO.
Publications
Return common citation information for Publications
SELECT ?doi ?infoResource_label ?pmid $type ?journal ?issn ?pubVenue ?issue ?startPage ?endPage ?volume ?dateTime WHERE{ ?infoResource vivo:hasPublicationVenue ?pubVenue . ?pubVenue rdf:type bibo:Journal . ?infoResource rdf:type $anyType . ?infoResource bibo:doi ?doi . ?infoResource bibo:pmid ?pmid . ?infoResource bibo:pageStart ?startPage . ?infoResource bibo:pageEnd ?endPage . ?pubVenue bibo:issn ?issn . OPTIONAL { ?pubVenue bibo:volume ?volume } . OPTIONAL { ?pubVenue vivo:DateTimeValue ?dateTime } . OPTIONAL { ?pubVenue bibo:issue ?issue } . ?pubVenue rdfs:label ?journal . ?anyType rdfs:label ?type . ?infoResource rdfs:label $infoResource_label . }
Authors
List authors of publications with their departments
SELECT ?infoResource_label ?type ?author ?firstName ?lastName ?position_label ?department ?pemail WHERE { ?infoResource vivo:hasPublicationVenue ?pubVenue . ?pubVenue rdf:type bibo:Journal . ?infoResource rdf:type ?anyType . ?anyType rdfs:label ?type . ?infoResource vivo:informationResourceInAuthorship ?authorship . ?authorship rdf:type vivo:Authorship . ?authorship vivo:linkedAuthor ?authorURI . ?authorURI rdfs:label ?author . ?infoResource rdfs:label ?infoResource_label . OPTIONAL { $authorURI foaf:firstName ?firstName } . OPTIONAL { $authorURI foaf:lastName ?lastName } . OPTIONAL { $authorURI vivo:primaryEmail ?pemail } . ?authorURI vivo:personInPosition ?position . ?position vivo:positionInOrganization $organization . ?organization rdfs:label ?department . ?position rdfs:label ?position_label .
List authors with less than five publications
SELECT ?person WHERE { ?person vivo:relatedBy ?a . ?a a vivo:Authorship. } GROUP BY ?person HAVING (COUNT(?a) < 2)