Publications
Code Block |
---|
SELECT ?doi ?infoResource_label ?pmid $type ?journal ?issn ?pubVenue ?issue ?startPage ?endPage ?volume ?dateTime |
...
...
?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
Code Block |
---|
SELECT ?infoResource_label ?type ?author ?firstName ?lastName ?position_label ?department ?pemail |
...
...
?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 . |
...
Find Authors with less than 5 publications
Useful for finding good test cases, for example. This is a Vivo 1.5 example, but could be updated pretty easily.
...
...
{
?person vivo:authorInAuthorship ?authorship. |
...
...
...
HAVING (COUNT(?authorship) < 5) |
...