Lists every observer-tier role association of a space ref (validated plus un-introduced self-declared, flagged via the headerless column). Excludes a member's observer association only when they hold a VALIDATED higher tier THROUGH THE SAME ROLE PROPERTY (npa:hasRoleType on a gen:RoleInstantiation in the current space state). BUGFIX over RAoW4pMA/RAZNHDFQ (nanodash#498): that version excluded the member whenever they held ANY validated higher-tier role, which hid an admin/maintainer/member from the observer list even for a separate, genuinely observer-tier role they hold (e.g. an admin who is also a planned attendant showed nowhere as an observer). Scoping the higher-tier check to the same role property restores the intended behaviour (every observer-tier association is listed) while keeping the #498 tier-collision fix: a property declared as observer globally but validated at a higher tier for this member in this ref is still excluded. Pending accounts (nanopub-query#195, nanodash#625): an association validated only through a pending account (the materialized gen:RoleInstantiation carries npa:trustStatus npa:seen) shows an hourglass in the same headerless flag column, so self-signed-up members awaiting approval are listed but visibly distinct. Flag semantics: empty = validated via an approved account; hourglass = validated via a pending (introduced but not yet approved) account; warning sign = not validated at all.
List space observers (ref-scoped, all observer-tier associations, with validation flag)
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 npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select ?member (group_concat(distinct ?latestNp; separator=" ") as ?role_assignments_multi_iri) (group_concat(distinct ?roleLabel; separator="\n") as ?role_assignments_label_multi) (if(max(?val) = 0, "⚠️", if(max(?pend) = 1, "⏳", "")) as ?unverified_noheader) (?member as ?revokeAgent) where { { select ?member ?roleProp (max(?val0) as ?val) (max(?pend0) as ?pend) (strafter(max(concat(coalesce(str(?dateNp),""), " ", str(?grantNp))), " ") as ?latestNp) (sample(?rl) as ?rlRaw) where { values ?_root_np_multi_iri {} graph npa:spacesGraph { ?ref npa:rootNanopub ?_root_np_multi_iri ; npa:spaceIri ?spaceIri . } graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?g . } graph npa:spacesGraph { ?ri a gen:RoleInstantiation ; npa:forSpace ?inSpace ; npa:forAgent ?member ; npa:viaNanopub ?grantNp ; (npa:regularProperty|npa:inverseProperty) ?roleProp . } filter( ?inSpace = ?spaceIri || exists { graph ?g { ?inSpace npa:sameAsSpace ?ref } } ) filter exists { graph npa:spacesGraph { ?rdf a npa:RoleDeclaration ; npa:hasRoleType gen:ObserverRole ; (gen:hasRegularProperty|gen:hasInverseProperty) ?roleProp } } filter(?roleProp != gen:hasAdmin) filter not exists { graph ?g { ?vriH a gen:RoleInstantiation ; npa:forSpaceRef ?ref ; npa:forAgent ?member ; (npa:regularProperty|npa:inverseProperty) ?roleProp . { ?vriH npa:hasRoleType gen:AdminRole } union { ?vriH npa:hasRoleType gen:MaintainerRole } union { ?vriH npa:hasRoleType gen:MemberRole } } } filter not exists { graph npa:graph { ?invNp npx:invalidates ?grantNp ; npa:hasValidSignatureForPublicKeyHash ?invpk . ?grantNp npa:hasValidSignatureForPublicKeyHash ?invpk . } } bind(if(exists { graph ?g { ?vri npa:forSpaceRef ?ref ; npa:forAgent ?member ; npa:viaNanopub ?grantNp } }, 1, 0) as ?val0) bind(if(exists { graph ?g { ?vriP a gen:RoleInstantiation ; npa:forSpaceRef ?ref ; npa:forAgent ?member ; npa:viaNanopub ?grantNp ; npa:trustStatus npa:seen } }, 1, 0) as ?pend0) optional { graph npa:graph { ?grantNp dct:created ?dateNp } } optional { graph ?g { ?raRole a gen:RoleAssignment ; npa:forSpaceRef ?ref ; gen:hasRole ?role . } graph npa:spacesGraph { ?rd2 a npa:RoleDeclaration ; npa:role ?role ; (gen:hasRegularProperty|gen:hasInverseProperty) ?roleProp ; npa:viaNanopub ?roleNp . } graph npa:graph { ?roleNp np:hasAssertion ?role_a . } optional { graph ?role_a { ?role schema:name ?rl } } } } group by ?member ?roleProp } bind(coalesce(?rlRaw, "role") as ?roleLabel) } group by ?member order by ?unverified_noheader ?member