@prefix this: . @prefix sub: . @prefix np: . @prefix grlc: . @prefix dct: . @prefix nt: . @prefix npx: . @prefix xsd: . @prefix rdfs: . @prefix orcid: . @prefix prov: . @prefix foaf: . sub:Head { this: a np:Nanopublication; np:hasAssertion sub:assertion; np:hasProvenance sub:provenance; np:hasPublicationInfo sub:pubinfo . } sub:assertion { sub:get-concluded-sub-space-projects a grlc:grlc-query; dct:description "Returns the concluded projects (defined as Spaces) that are sub-spaces of the given space, together with their top-down approved project lead. A project counts as concluded when it has an end date that lies before today."; dct:license ; rdfs:label "Get concluded sub-space projects"; grlc:endpoint ; grlc:sparql """prefix rdfs: prefix dct: prefix np: prefix npa: prefix npx: prefix gen: prefix schema: prefix foaf: prefix xsd: select distinct ?project ?project_label ?dates ?lead ?lead_label ?description ?np (\"^\" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npx:introduces ?project . ?np np:hasAssertion ?a . ?np dct:created ?npDate . filter not exists { ?np2 npx:introduces ?project . ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } ?np2 dct:created ?npDate2 . filter(?npDate2 > ?npDate) } } graph ?a { ?project a gen:Space . ?project a gen:Project . ?project rdfs:label ?project_label . optional { ?project dct:description ?description . } optional { ?project schema:startDate ?datetime . } ?project schema:endDate ?endDatetime . } service { graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?stateG . } graph ?stateG { ?_resource_iri npa:hasSubSpace ?project . } optional { graph npa:spacesGraph { ?riStem (npa:regularProperty|npa:inverseProperty) gen:hasProjectLead ; npa:forSpace ?project ; npa:forAgent ?lead . } graph ?stateG { ?riFull npa:forSpace ?project ; npa:forAgent ?lead . } filter(strstarts(str(?riFull), concat(str(?riStem), \"__\"))) optional { graph ?stateG { ?lead foaf:name ?lead_label } } } } bind(xsd:date(substr(str(?endDatetime), 1, 10)) as ?endDate) bind(xsd:date(substr(str(now()), 1, 10)) as ?today) filter(?endDate < ?today) bind(substr(str(?datetime), 1, 10) as ?startDay) bind(substr(str(?endDatetime), 1, 10) as ?endDay) bind(if(!bound(?datetime), ?endDay, if(?startDay = ?endDay, concat(?startDay, \" \", substr(str(?datetime), 12, 5)), concat(?startDay, \" – \", ?endDay))) as ?dates) } order by ?startDay""" . } sub:provenance { sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 . } sub:pubinfo { orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" . this: dct:created "2026-06-23T13:17:12Z"^^xsd:dateTime; dct:creator orcid:0000-0002-1267-0234; dct:license ; npx:introduces sub:get-concluded-sub-space-projects; npx:supersedes ; nt:wasCreatedFromProvenanceTemplate ; nt:wasCreatedFromPubinfoTemplate , ; nt:wasCreatedFromTemplate . sub:sig npx:hasAlgorithm "RSA"; npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"; npx:hasSignature "H1F4pPFJMeIPMP95fpMwC9ebT57LsRevSNlqGtRb/FEWr6M/6pUhRwDpkG3Gtdcye47CsCx5X1dsr0XKJcL6Otg1kqAaCkzPyesuIPd1UzQYJIZg+eYbBIzGd3gGjhIoeQv1d/A6elw6rpDlo0X68Mos+BScvF1ALVMyKicoRBU="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }