@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-ongoing-and-upcoming-sub-space-projects a grlc:grlc-query; dct:description "Returns the ongoing and upcoming projects (defined as Spaces) that are sub-spaces of the given space, together with their top-down approved project lead. A project counts as ongoing/upcoming when it has no end date or its end date is today or later."; dct:license ; rdfs:label "Get ongoing and upcoming 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 . } optional { ?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(?datetime), 1, 10)) as ?startDate) bind(xsd:date(substr(str(?endDatetime), 1, 10)) as ?endDate) bind(xsd:date(substr(str(now()), 1, 10)) as ?today) filter(!bound(?endDate) || ?endDate >= ?today) bind(substr(str(?datetime), 1, 10) as ?startDay) bind(if(bound(?endDatetime), substr(str(?endDatetime), 1, 10), ?startDay) as ?endDay) bind(if(?startDay = ?endDay, concat(?startDay, \" \", substr(str(?datetime), 12, 5)), concat(?startDay, \" – \", ?endDay)) as ?dates) } order by ?startDate""" . } 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-ongoing-and-upcoming-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 "EeYoW+hBUEZaH5efjXcgkTMdqAW3IrFnQsKagSgx2DGJk5PgFDKqgM58u0BhMWrAW9AWBg4HvlVmMcIzQ/Y+b4DI9qa43XucuF+ZQj7+chAvoKjIItaPKitTev78wQgQ9Z6i8CctiyQn3nI/d0/mia0bydQhW/cSJU/BR00iZYo="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }