. . . . "Returns the details of a single nanosuggestion as field/value rows for a compact info card: title, kind, text, current status, assignee, the spaces it is relevant for, what it is about, and further links. Values that are IRIs are returned as IRIs so they render as links, with a companion label column supplying the link text. Empty fields are omitted and only the most recent status assertion is shown. Runs entirely on the schema:Statement type repository: labels are derived locally rather than looked up, so the query does not depend on the full repository." . . . "Get the details of a nanosuggestion" . . "\nprefix rdf: \nprefix rdfs: \nprefix dct: \nprefix foaf: \nprefix np: \nprefix npa: \nprefix npx: \nprefix schema: \nprefix gen: \nprefix nsug: \n\nselect distinct ?Property_noheader ?Value_noheader ?Value_label where {\n values (?property ?Property_noheader ?ord) {\n ( rdfs:label 'Title:' '1' )\n ( rdf:type 'Kind:' '2' )\n ( rdf:value 'Text:' '3' )\n ( dct:description 'Text:' '3' )\n ( schema:actionStatus 'Status:' '4' )\n ( schema:agent 'Assigned to:' '5' )\n ( gen:isRelevantFor 'Relevant for:' '6' )\n ( schema:about 'About:' '7' )\n ( rdfs:seeAlso 'More info:' '8' )\n }\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKeyHash ?pubkey ; np:hasAssertion ?a ; dct:created ?d .\n filter not exists { ?npi npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }\n }\n graph ?a { ?_suggestion_iri ?property ?Value_noheader . }\n # the base types are structural, not the \"kind\"\n filter(!(?property = rdf:type && (?Value_noheader = nsug:Nanosuggestion || ?Value_noheader = schema:Statement)))\n # of the status assertions keep only the newest. The date is computed in a sub-select,\n # which is an optimizer barrier: as a NOT EXISTS this had an unconstrained\n # \"?np2 npa:hasValidSignatureForPublicKeyHash ?pk2\" that the planner evaluated first,\n # and it started failing with \"Queue full\" once /repo/full grew past a threshold.\n optional {\n { select (max(?sd) as ?maxStatusDate) where {\n graph npa:graph {\n ?snp npa:hasValidSignatureForPublicKeyHash ?spk ; np:hasAssertion ?sa ; dct:created ?sdate .\n filter not exists { ?snpi npx:invalidates ?snp ; npa:hasValidSignatureForPublicKeyHash ?spk . }\n }\n graph ?sa { ?_suggestion_iri schema:actionStatus ?anyStatus . }\n bind(str(?sdate) as ?sd)\n } }\n }\n filter(?property != schema:actionStatus || coalesce(str(?d) = ?maxStatusDate, true))\n # labels are derived locally, so this query needs only the type repository\n optional { ?Value_noheader foaf:name ?agentName }\n bind(if(?Value_noheader = schema:PotentialActionStatus, 'open',\n if(?Value_noheader = schema:ActiveActionStatus, 'in progress',\n if(?Value_noheader = schema:CompletedActionStatus, 'done',\n if(?Value_noheader = schema:FailedActionStatus, 'rejected',\n if(?property = rdf:type, lcase(replace(str(?Value_noheader), '^.*/', '')),\n if(?property = gen:isRelevantFor, replace(str(?Value_noheader), '^.*/', ''),\n coalesce(?agentName, ''))))))) as ?Value_label)\n}\norder by ?ord ?Value_label\n" . . "Tobias Kuhn" . "2026-08-27T06:32:41Z"^^ . . . . . "Get the details of a nanosuggestion" . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "Zxi3r22FeTTGt8irCo2bVA7WWS702/MduG07WftcbsX7BeIv+f+ZCu7hmmnTIDVrvvfQtkeS+X0eb4UcQ17AxnbvVS0qqhnnxxaz5WlYnzpEoMdSdJnrks3GgM+rIHv2e1YxR0GW6w37sZ4bAwty5G7dKCCpRnjSvohNT07yFsk=" . . .