@prefix this: . @prefix sub: . @prefix np: . @prefix grlc: . @prefix dct: . @prefix nt: . @prefix npx: . @prefix xsd: . @prefix rdfs: . @prefix orcid: . @prefix prov: . @prefix foaf: . sub:Head { this: a np:Nanopublication; np:hasAssertion sub:assertion; np:hasProvenance sub:provenance; np:hasPublicationInfo sub:pubinfo . } sub:assertion { sub:get-nanosuggestion-details a grlc:grlc-query; dct:description "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."; dct:license ; rdfs:label "Get the details of a nanosuggestion"; grlc:endpoint ; grlc:sparql """ prefix rdf: prefix rdfs: prefix dct: prefix foaf: prefix np: prefix npa: prefix npx: prefix schema: prefix gen: prefix nsug: 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 """ . } sub:provenance { sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 . } sub:pubinfo { orcid:0000-0002-1267-0234 foaf:name "Tobias Kuhn" . this: dct:created "2026-08-27T06:32:41Z"^^xsd:dateTime; dct:creator orcid:0000-0002-1267-0234; dct:license ; npx:embeds sub:get-nanosuggestion-details; npx:supersedes ; rdfs:label "Get the details of a nanosuggestion"; nt:wasCreatedFromProvenanceTemplate ; nt:wasCreatedFromPubinfoTemplate , , ; nt:wasCreatedFromTemplate . sub:sig npx:hasAlgorithm "RSA"; npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"; npx:hasSignature "Zxi3r22FeTTGt8irCo2bVA7WWS702/MduG07WftcbsX7BeIv+f+ZCu7hmmnTIDVrvvfQtkeS+X0eb4UcQ17AxnbvVS0qqhnnxxaz5WlYnzpEoMdSdJnrks3GgM+rIHv2e1YxR0GW6w37sZ4bAwty5G7dKCCpRnjSvohNT07yFsk="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }