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
SELECT ?doi ?pub_label ?type_label ?venue_label ?issn ?issue ?startPage ?endPage ?volume ?year WHERE{ ?pub vivo:hasPublicationVenue ?venue . ?venue rdf:type bibo:Journal . ?venue bibo:issn ?issn . ?venue rdfs:label ?venue_label . ?pub rdfs:label $pub_label . ?pub vitro:mostSpecificType ?type . ?type rdfs:label ?type_label . ?pub vivo:dateTimeValue ?dtv . ?dtv vivo:dateTime ?dt . BIND(SUBSTR(str(?dt),1,4) AS ?year) OPTIONAL { ?pub bibo:doi ?doi . } OPTIONAL { ?pub bibo:pageStart ?startPage . } OPTIONAL { ?pub bibo:pageEnd ?endPage . } OPTIONAL { ?pub bibo:volume ?volume . } OPTIONAL { ?pub bibo:issue ?issue . } }
Authors
List Authors by Department
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 .
People with less than five publications
In the query below we select people that have at least one publication, but less than five. VIVO uses "relatedBy" to associate people with authorships that indicate that the person is an author of the paper. Note that the query insures that ?person is a foaf:Person and ?a is a vivo:Authorship. relatedBy is used in other contexts so it is very important that we clarify which relatedBy assertions we are interested in.
SELECT ?person WHERE { ?person vivo:relatedBy ?a . ?person a foaf:Person . ?a a vivo:Authorship . } GROUP BY ?person HAVING (COUNT(?a) < 5)