@prefix this: . @prefix sub: . @prefix np: . @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:list-space-roles a ; dct:description "Lists the roles assigned in a given space as a table: each role (linked, labelled by its schema:name, falling back to its label/title), its tier (Admin/Maintainer/Member/Observer), a count of how many distinct users of the space hold that role, the contributing preset (via_preset, for roles carried by an active preset assignment), who added it, and the date. The built-in Admin role is always included as the first row. Also returns the role-assignment template (for the assign-user action) and the source nanopublication."; dct:license ; rdfs:label "List space roles"; ; """prefix rdfs: prefix dct: prefix np: prefix npa: prefix npx: prefix schema: prefix gen: select ?role (sample(?rlbl) as ?role_label) (sample(?rtier) as ?tier) (count(distinct ?member) as ?users) (sample(?presetX) as ?via_preset) (sample(?presetXlbl) as ?via_preset_label) (sample(?userX) as ?added_by) (max(?dateX) as ?date_added) (sample(?rtmpl) as ?roleAssignmentTemplate) (sample(?npX) as ?np) where { graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?g . } values ?_space_multi_iri {} { bind( as ?role) bind(0 as ?sortkey) bind(\"admin\" as ?rlbl) bind(\"Admin\" as ?rtier) bind( as ?rtmpl) bind(gen:hasAdmin as ?prop) } union { graph ?g { ?ra a gen:RoleAssignment ; npa:forSpace ?_space_multi_iri ; gen:hasRole ?role ; npa:viaNanopub ?npX . } graph npa:graph { ?npX dct:created ?dateX . } optional { graph npa:graph { ?npX npx:signedBy ?userX . } } bind(1 as ?sortkey) graph npa:spacesGraph { ?roleDecl a npa:RoleDeclaration ; npa:role ?role ; npa:viaNanopub ?role_np . } bind(exists { graph npa:spacesGraph { ?roleDecl npa:hasRoleType gen:MaintainerRole } } as ?isMaintainer) bind(exists { graph npa:spacesGraph { ?roleDecl npa:hasRoleType gen:MemberRole } } as ?isMember) bind(if(?isMaintainer,\"Maintainer\",if(?isMember,\"Member\",\"Observer\")) as ?rtier) graph npa:graph { ?role_np np:hasAssertion ?role_a . } optional { graph ?role_a { ?role rdfs:label ?rl1 } } optional { graph ?role_a { ?role dct:title ?rt1 } } optional { graph ?role_a { ?role schema:name ?rn1 } } optional { graph ?role_a { ?role gen:hasRoleAssignmentTemplate ?rtmpl } } bind(coalesce(?rn1, ?rl1, ?rt1) as ?rlbl) optional { { graph npa:spacesGraph { ?roleDecl gen:hasRegularProperty ?prop } } union { graph npa:spacesGraph { ?roleDecl gen:hasInverseProperty ?prop } } } } union { { select ?role ?presetX ?presetXlbl ?userX ?npX ?dateX ?pubkeyA ?_space_multi_iri { service { graph npa:graph { ?npX npx:hasNanopubType gen:PresetAssignment ; npa:hasValidSignatureForPublicKeyHash ?pubkeyA ; dct:created ?dateX ; npx:embeds ?assignment ; np:hasAssertion ?aX . filter not exists { ?invX npx:invalidates ?npX ; npa:hasValidSignatureForPublicKeyHash ?pubkeyA . } optional { ?npX npx:signedBy ?userX } } graph ?aX { ?assignment gen:isAssignmentFor ?_space_multi_iri ; gen:isAssignmentOfPreset ?presetX . optional { values ?mX { gen:ActivatedPresetAssignment gen:DeactivatedPresetAssignment } ?assignment a ?mX . } } filter(!bound(?mX) || !contains(str(?mX), \"Deactivated\")) filter not exists { graph npa:graph { ?np2 npx:hasNanopubType gen:PresetAssignment ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 ; dct:created ?date2 ; npx:embeds ?assignment2 ; np:hasAssertion ?a2 . filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } } graph ?a2 { ?assignment2 a gen:DeactivatedPresetAssignment ; gen:isAssignmentFor ?_space_multi_iri ; gen:isAssignmentOfPreset ?presetX . } filter(?date2 > ?dateX) } graph npa:graph { ?presetNp npx:embeds ?presetX ; np:hasAssertion ?paX . } graph ?paX { ?presetX a gen:Preset . optional { ?presetX rdfs:label ?presetXlbl . } ?presetX gen:hasRole ?role . } } } } graph ?g { ?riA a gen:RoleInstantiation ; npa:forSpace ?_space_multi_iri ; npa:forAgent ?authAgent ; (npa:inverseProperty|npa:regularProperty) ?rolePropA . ?authAcct a npa:AccountState ; npa:agent ?authAgent ; npa:pubkey ?pubkeyA . } optional { graph npa:spacesGraph { ?rdA a npa:RoleDeclaration ; npa:forSpace ?_space_multi_iri ; npa:hasRoleType gen:MaintainerRole ; (npa:inverseProperty|npa:regularProperty) ?rolePropA . bind(true as ?isMaintA) } } filter(?rolePropA = gen:hasAdmin || bound(?isMaintA)) bind(1 as ?sortkey) graph npa:spacesGraph { ?roleDecl a npa:RoleDeclaration ; npa:role ?role ; npa:viaNanopub ?role_np . } bind(exists { graph npa:spacesGraph { ?roleDecl npa:hasRoleType gen:MaintainerRole } } as ?isMaintainer) bind(exists { graph npa:spacesGraph { ?roleDecl npa:hasRoleType gen:MemberRole } } as ?isMember) bind(if(?isMaintainer,\"Maintainer\",if(?isMember,\"Member\",\"Observer\")) as ?rtier) graph npa:graph { ?role_np np:hasAssertion ?role_a . } optional { graph ?role_a { ?role rdfs:label ?rl1 } } optional { graph ?role_a { ?role dct:title ?rt1 } } optional { graph ?role_a { ?role schema:name ?rn1 } } optional { graph ?role_a { ?role gen:hasRoleAssignmentTemplate ?rtmpl } } bind(coalesce(?rn1, ?rl1, ?rt1) as ?rlbl) optional { { graph npa:spacesGraph { ?roleDecl gen:hasRegularProperty ?prop } } union { graph npa:spacesGraph { ?roleDecl gen:hasInverseProperty ?prop } } } } optional { graph ?g { ?ri a gen:RoleInstantiation ; npa:forSpace ?_space_multi_iri ; npa:forAgent ?member . } optional { graph ?g { ?ri (npa:regularProperty|npa:inverseProperty) ?riPropS } } optional { graph npa:spacesGraph { ?ri (npa:regularProperty|npa:inverseProperty) ?riPropX } } bind(coalesce(?riPropS, ?riPropX) as ?riProp) filter(bound(?prop) && ?riProp = ?prop) } } group by ?role ?sortkey order by ?sortkey desc(max(?dateX))""" . } 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-12T18:27:09Z"^^xsd:dateTime; dct:creator orcid:0000-0002-1267-0234; dct:license ; npx:embeds sub:list-space-roles; npx:supersedes ; rdfs:label "List space roles"; nt:wasCreatedFromProvenanceTemplate ; nt:wasCreatedFromPubinfoTemplate , , ; nt:wasCreatedFromTemplate . sub:sig npx:hasAlgorithm "RSA"; npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"; npx:hasSignature "rr+KB3JnysHnMsB8yr8o2SAPmCaRQByiYDS1zEq6GA6dCwD8RjBfByuubTikZfFKQWXfgSuLOghaFlfE3X8klO1HAfx//OLV89sxrDvkkusCZeOWhWVB7yWQpt01vX69e4n+t+NlUD7gUvSDMcJ99V2bodp7Vj2vi8bBp7Tfr6c="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }