find-things/queries/q5.sparql
2025-11-27 17:50:29 +01:00

22 lines
957 B
SPARQL

# Q5: Who has which role in which project?
PREFIX dlrelationsmx: <https://concepts.datalad.org/s/relations-mixin/unreleased/>
PREFIX dlprovmx: <https://concepts.datalad.org/s/prov-mixin/unreleased/>
PREFIX dlsocialmx: <https://concepts.datalad.org/s/social-mixin/unreleased/>
PREFIX frapo: <http://purl.org/cerif/frapo/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xyzra: <https://concepts.datalad.org/s/demo-rse-group/unreleased/>
SELECT ?project ?full_name ?label WHERE {
?project rdf:type xyzra:XYZProject .
?project dlprovmx:associated_with ?activity .
?activity rdf:object ?object .
?activity dlrelationsmx:roles ?roles .
?roles rdf:type xyzra:XYZAgentRole .
?roles skos:prefLabel ?label .
?object dlsocialmx:family_name ?family_name .
?object dlsocialmx:given_name ?given_name .
BIND(concat(?family_name,", ",?given_name) AS ?full_name)
}