. . . . "Lists the presets assigned in a given space ref (space IRI + root definition). Pass the ref's root nanopub (root_np); the query resolves the ref via npa:rootNanopub and reads the server-materialised npa:PresetAssignment rows scoped by npa:forSpaceRef from the trust-validated current space-state graph (only admin-authored assignments are materialised, so this is authorisation-scoped). An assignment is identified by the assigned preset's stable KIND (dct:isVersionOf) and the resource, mirroring view displays, which the client dedups by view kind (nanodash issue #607): among the assignments of one preset kind for one resource only the latest by dct:created counts, so assigning another version of the same preset replaces the earlier assignment instead of adding a second, competing row; a version declaring no kind keys on itself, and the preset listed is the version that assignment pinned. The preset is listed only when that latest row is still activated (npa:isActivated true) -- a deactivation is a newer admin-authored row with npa:isActivated false. The update columns surface a newer version of the assigned preset (update_noheader is the notice, update_label its tooltip, updatePreset the version the update action pre-fills): the newest non-invalidated version of the same kind, restricted to versions published by the same agent as the assigned version, so an unrelated agent cannot advertise a version of someone else's preset here. Presets never auto-update -- adopting the newer version stays an explicit, admin-signed act. Columns match the IRI-keyed list-preset-assignments (preset, preset_label, deactivatePreset, added_by, date_added, update_noheader, update_label, updatePreset, np, np_label) so it drives the existing Preset assignments view unchanged. Ref-scoped variant: shows only that one ref's assignments rather than merging all refs claiming the IRI." . . . "List preset assignments (ref-scoped)" . . "prefix rdfs: \nprefix dct: \nprefix np: \nprefix npa: \nprefix npx: \nprefix gen: \n\nselect ?preset (sample(?lbl) as ?preset_label) (str(?preset) as ?deactivatePreset)\n (sample(?user) as ?added_by) (?date as ?date_added)\n (sample(?update) as ?update_noheader) (sample(?updateNote) as ?update_label)\n (sample(?updateTarget) as ?updatePreset)\n ?np (\"^\" as ?np_label)\nwhere {\n values ?_root_np_multi_iri {}\n graph npa:spacesGraph { ?ref npa:rootNanopub ?_root_np_multi_iri . }\n graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?g . }\n graph ?g {\n ?paRef a npa:PresetAssignment ; npa:forSpaceRef ?ref ; npa:ofPreset ?preset ; npa:forResource ?resource ;\n npa:isActivated ?activated ; npa:viaNanopub ?np ; dct:created ?date .\n }\n # The assigned preset version: its label, its stable kind, its author and its date.\n optional {\n ?pnp npx:embeds ?preset ; np:hasAssertion ?pa .\n optional { graph npa:graph { ?pnp npx:signedBy ?presetSigner } }\n optional { graph npa:graph { ?pnp dct:created ?presetDate } }\n graph ?pa {\n optional { ?preset rdfs:label ?lbl }\n optional { ?preset dct:isVersionOf ?presetKindOptional }\n }\n }\n # Assignment identity is (preset KIND, resource) -- as for view displays, where the\n # client dedups by view kind -- so assigning another version of the same preset\n # replaces the earlier assignment instead of adding a second, competing one. A\n # version that declares no kind keys on itself.\n bind(coalesce(?presetKindOptional, ?preset) as ?presetKey)\n filter(?activated = true)\n filter not exists {\n graph ?g { ?pa2 a npa:PresetAssignment ; npa:forSpaceRef ?ref ; npa:ofPreset ?preset2 ;\n npa:forResource ?resource ; npa:viaNanopub ?np2 ; dct:created ?date2 . }\n optional {\n ?pnp2 npx:embeds ?preset2 ; np:hasAssertion ?pa2Assertion .\n graph ?pa2Assertion { ?preset2 dct:isVersionOf ?presetKind2 }\n }\n filter(coalesce(?presetKind2, ?preset2) = ?presetKey)\n filter(?date2 > ?date || (?date2 = ?date && str(?np2) > str(?np)))\n }\n # Newest version of the assigned preset's kind, restricted to versions published by\n # the same agent as the assigned version, so an unrelated agent cannot advertise a\n # version of someone else's preset here (issue #607). Presets never auto-update:\n # this only surfaces the newer version and pre-fills the update action with it.\n optional {\n { select (?versionKind as ?presetKey) (?versionSigner as ?presetSigner)\n (iri(strafter(max(concat(str(?vDate), \">\", str(?vPreset))), \">\")) as ?latestVersion)\n (max(?vDate) as ?latestDate) where {\n graph npa:graph {\n ?vNp npx:hasNanopubType gen:Preset ;\n npa:hasValidSignatureForPublicKeyHash ?vPubkey ;\n dct:created ?vDate ;\n npx:signedBy ?versionSigner ;\n npx:embeds ?vPreset ;\n np:hasAssertion ?vA .\n filter not exists { ?vInv npx:invalidates ?vNp ; npa:hasValidSignatureForPublicKeyHash ?vPubkey . }\n }\n graph ?vA { ?vPreset a gen:Preset ; dct:isVersionOf ?versionKind . }\n } group by ?versionKind ?versionSigner }\n }\n bind(bound(?latestVersion) && ?latestVersion != ?preset && ?latestDate > ?presetDate as ?hasUpdate)\n bind(if(?hasUpdate, \"⬆️ newer version available\", \"\") as ?update)\n bind(if(?hasUpdate, concat(\"Version of \", substr(str(?latestDate), 1, 10), \" is newer than the assigned one\"), \"\") as ?updateNote)\n bind(if(?hasUpdate, str(?latestVersion), \"\") as ?updateTarget)\n optional { graph npa:graph { ?np npx:signedBy ?user } }\n}\ngroup by ?preset ?date ?np\norder by desc(?date)\n" . . "Tobias Kuhn" . "2026-09-09T06:25:41Z"^^ . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "F1c2jsp8NU6hK25v/e0THoCsmT4+znz+MNDTVPSoCitrqwPaYlNP76fuKVbk7cCklq1TDnFbMGeLq+urDfF5ucXgPzJ2eMlkhF8rH0e9vaKEmYWPFBbWU8potat7Fdj/zJmHHTm8NesfJ0XfY2T5IciDx+BVfzyUPcn5HBFh0Io=" . . .