Lists the roles assigned in a given space as a table: each role (linked, labelled by its title/label), its schema:name, and a count of how many distinct users of the space hold that role. 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.
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix schema: <http://schema.org/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?role (sample(?rlbl) as ?role_label) (sample(?rname) as ?name) (count(distinct ?member) as ?users) (sample(?rtmpl) as ?roleAssignmentTemplate) (sample(?npX) as ?np) where { graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?g . } values ?_space_multi_iri {} { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) bind(0 as ?sortkey) bind("Admins" as ?rlbl) bind("admin" as ?rname) bind(<https://w3id.org/np/RAsOQ7k3GNnuUqZuLm57PWwWopQJR_4onnCpNR457CZg8> 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 . } bind(1 as ?sortkey) graph npa:spacesGraph { ?roleDecl a npa:RoleDeclaration ; npa:role ?role ; npa:viaNanopub ?role_np . } 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(?rt1, ?rl1, ?rn1) as ?rlbl) bind(?rn1 as ?rname) 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))