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.
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix nsug: <https://w3id.org/np/RA5BAdUvlxLWMWFQN3UVKoIQEB_MYTiAoLH1klXJ7z-XI/> select distinct ?Property_noheader ?Value_noheader ?Value_label where { values (?property ?Property_noheader ?ord) { ( rdfs:label 'Title:' '1' ) ( rdf:type 'Kind:' '2' ) ( rdf:value 'Text:' '3' ) ( dct:description 'Text:' '3' ) ( schema:actionStatus 'Status:' '4' ) ( schema:agent 'Assigned to:' '5' ) ( gen:isRelevantFor 'Relevant for:' '6' ) ( schema:about 'About:' '7' ) ( rdfs:seeAlso 'More info:' '8' ) } graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey ; np:hasAssertion ?a ; dct:created ?d . filter not exists { ?npi npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } } graph ?a { ?_suggestion_iri ?property ?Value_noheader . } # the base types are structural, not the "kind" filter(!(?property = rdf:type && (?Value_noheader = nsug:Nanosuggestion || ?Value_noheader = schema:Statement))) # of the status assertions keep only the newest. The date is computed in a sub-select, # which is an optimizer barrier: as a NOT EXISTS this had an unconstrained # "?np2 npa:hasValidSignatureForPublicKeyHash ?pk2" that the planner evaluated first, # and it started failing with "Queue full" once /repo/full grew past a threshold. optional { { select (max(?sd) as ?maxStatusDate) where { graph npa:graph { ?snp npa:hasValidSignatureForPublicKeyHash ?spk ; np:hasAssertion ?sa ; dct:created ?sdate . filter not exists { ?snpi npx:invalidates ?snp ; npa:hasValidSignatureForPublicKeyHash ?spk . } } graph ?sa { ?_suggestion_iri schema:actionStatus ?anyStatus . } bind(str(?sdate) as ?sd) } } } filter(?property != schema:actionStatus || coalesce(str(?d) = ?maxStatusDate, true)) # labels are derived locally, so this query needs only the type repository optional { ?Value_noheader foaf:name ?agentName } bind(if(?Value_noheader = schema:PotentialActionStatus, 'open', if(?Value_noheader = schema:ActiveActionStatus, 'in progress', if(?Value_noheader = schema:CompletedActionStatus, 'done', if(?Value_noheader = schema:FailedActionStatus, 'rejected', if(?property = rdf:type, lcase(replace(str(?Value_noheader), '^.*/', '')), if(?property = gen:isRelevantFor, replace(str(?Value_noheader), '^.*/', ''), coalesce(?agentName, ''))))))) as ?Value_label) } order by ?ord ?Value_label