You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 5
Next »
on 8/27/13, Eliza writes:
Hello,
We'd like to display the citation counts for articles listed on the profile pages.
So I modified the configuration file and added a citation count variable to the query.
However, the freemarker template didn't seem to pick up that variable.
See below for what was changed in the listViewConfig-authorInAuthorship.xml file:
<query-select>
SELECT DISTINCT ?subclass
?authorship
?infoResource
?infoResourceName
?globalCitationCount
?dateTime
?journal
?volume
?startPage
?endPage
?publisher
?locale
?appearsIn
?partOf
?editor
?hideThis
WHERE {
?subject ?property ?authorship
}
}
}
}
}
}
}
?hasGlobalCitationFrequencyObj
rdfs:label ?globalCitationCount
}
}
<critical-data-required>
FILTER ( bound(?infoResource) )
</critical-data-required>
} ORDER BY DESC(?dateTime) ?infoResourceName
</query-select>
And the template propStatement-authorInAuthorship.ftl:
…
<#local timesCited>
<#if statement.subclass??>
<#if statement.globalCitationCount??>
<br/>${statement.globalCitationCount!}
</#if>
</#if>
</#local>
${resourceTitle} ${citationDetails} <@dt.yearSpan "${statement.dateTime!}" /> ${resourceType} ${timesCited}
…
Any reason why it's not working?
Resolution:
on 8/28/13, Eliza writes:
It's finally resolved, but not until moving the variable to another construct:
<query-construct>
CONSTRUCT {
?subject ?property ?authorship .
?authorship ?authorshipProperty ?authorshipValue .
?hasGlobalCitationFrequencyObj
rdfs:label ?globalCitationCount
} WHERE {
{
?subject ?property ?authorship
}
UNION {
?subject ?property ?authorship .
?authorship ?authorshipProperty ?authorshipValue
} UNION {
?subject ?property ?authorship .
} UNION {
?subject ?property ?authorship .
} UNION {
?subject ?property ?authorship .
} UNION {
?subject ?property ?authorship .
} UNION {
?subject ?property ?authorship .
?hasGlobalCitationFrequencyObj
rdfs:label ?globalCitationCount
}
}
</query-construct>
This time, it was able to pick up the variable.
Not exactly sure why but it's working.
SPARQL Query to Retrieve the Position for a single Person
Live Results: (Note: You can click on the link below to run this query in realtime at http://sparql.vivo.ufl.edu. Be patient, it make take a few minutes to return.)
(http://sparql.vivo.ufl.edu/VIVO/query?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+rdf%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+bibo%3A+%3Chttp%3A%2F%2Fpurl.org%2Fontology%2Fbibo%2F%3E%0D%0APREFIX+core%3A+%3Chttp%3A%2F%2Fvivoweb.org%2Fontology%2Fcore%23%3E%0D%0APREFIX+ands%3A+%3Chttp%3A%2F%2Fpurl.org%2Fands%2Fontologies%2Fvivo%2F%3E%0D%0ASELECT++*+WHERE%0D%0A%7B%0D%0A%3FURI+core%3AprimaryEmail++%27cpb%40ufl.edu%27.%0D%0A%3FURI+core%3ApersonInPosition+%3FpositionURI.%0D%0A%3FpositionURI+rdfs%3Alabel+%3FPostionlabel%0D%0A%7D&output=text&stylesheet=%2Fxml-to-html.xsl)
SPARQL QUERY
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bibo: <http://purl.org/ontology/bibo/>
PREFIX core: <http://vivoweb.org/ontology/core#>
PREFIX ands: <http://purl.org/ands/ontologies/vivo/>
SELECT * WHERE
{
?URI core:primaryEmail 'cpb@ufl.edu'.
?URI core:personInPosition ?positionURI.
?positionURI rdfs:label ?Postionlabel
}
Live Results in JSON:
http://sparql.vivo.ufl.edu/VIVO/query?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+rdf%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+bibo%3A+%3Chttp%3A%2F%2Fpurl.org%2Fontology%2Fbibo%2F%3E%0D%0APREFIX+core%3A+%3Chttp%3A%2F%2Fvivoweb.org%2Fontology%2Fcore%23%3E%0D%0APREFIX+ands%3A+%3Chttp%3A%2F%2Fpurl.org%2Fands%2Fontologies%2Fvivo%2F%3E%0D%0ASELECT++*+WHERE%0D%0A%7B%0D%0A%3FURI+core%3AprimaryEmail++%27cpb%40ufl.edu%27.%0D%0A%3FURI+core%3ApersonInPosition+%3FpositionURI.%0D%0A%3FpositionURI+rdfs%3Alabel+%3FPostionlabel%0D%0A%7D&output=json&stylesheet=%2Fxml-to-html.xsl
JSON Result
{
"head": {
"vars": [ "URI" , "positionURI" , "Postionlabel" ]
} ,
"results": {
"bindings": [
{
"URI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n64866" } ,
"positionURI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n136666" } ,
"Postionlabel": { "datatype": "http://www.w3.org/2001/XMLSchema#string" , "type": "typed-literal" , "value": "Assistant Director and Senior Architect" }
} ,
{
"URI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n64866" } ,
"positionURI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n31884" } ,
"Postionlabel": { "datatype": "http://www.w3.org/2001/XMLSchema#string" , "type": "typed-literal" , "value": "Associate Director" }
} ,
{
"URI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n64866" } ,
"positionURI": { "type": "uri" , "value": "http://vivo.ufl.edu/individual/n908759050" } ,
"Postionlabel": { "datatype": "http://www.w3.org/2001/XMLSchema#string" , "type": "typed-literal" , "value": "Associate Director, Software Engineering" }
}
]
}
}
Javascript Example to run query and get back JSON
Get the code here
https://github.com/senrabc/vivoSparqlExamples/blob/master/SPARQLExamplePositions.html
Set it run here:
http://senrabc.github.io/vivoSparqlExamples/
References
Live Google Doc: https://docs.google.com/document/d/1FlGWCG0nqQ4TAVZmnKXiVMZnGxpygdcoxRcZsxw4UG0/edit#heading=h.jx71i6lwn9um
Static Document: SPARQLExamplePositions.pdf