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 ?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
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 .
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.
List authors with less than five publications
SELECT ?person
WHERE
{
?person vivo:relatedBy ?a .
?person a foaf:Person .
?a a vivo:Authorship .
}
GROUP BY ?person
HAVING (COUNT(?a) < 5)
