. . . . "Lists the ideas (instances of the Idea class, published with the \"Suggesting an idea\" template) that are suggested for a given space or maintained resource, most up-voted first, then oldest first. An up-vote is a schema:VoteAction whose schema:object is the idea; the count is the number of distinct signing keys with a valid, non-retracted up-vote, so each person counts once per idea and a retracted up-vote no longer counts. Ideas and up-votes marked as example nanopublications, and superseded or invalidated ones, are ignored. The hidden action columns are computed against the viewer's local key (?__LOCALPUBKEY_multi): upvote_target holds the idea unless the viewer has already up-voted it, withdraw_target holds the viewer's own up-vote nanopublication if there is one (to retract it), and edit_target holds the idea nanopublication if the viewer's key signed it (to supersede it)." . . . "Get the ideas suggested for a resource with their up-votes" . . "prefix rdfs: \nprefix dct: \nprefix np: \nprefix npa: \nprefix npx: \nprefix gen: \nprefix schema: \nprefix foaf: \nprefix idea: \n\nselect ?idea ?idea_label ?description ?votes ?proposer ?proposer_label ?date ?np ?np_label ?upvote_target ?withdraw_target ?edit_target\nwhere {\n {\n select ?idea ?np ?a ?pk ?created\n (min(str(?lbl)) as ?idea_label) (sample(?desc) as ?description)\n (min(str(?prop)) as ?propS) (min(str(?pname)) as ?proposer_label)\n where {\n {\n select ?idea ?np ?a ?pk ?created where {\n values ?_target_multi_iri {}\n graph ?a { ?idea a idea:Idea ; gen:isRelevantFor ?_target_multi_iri . }\n graph npa:graph {\n ?np np:hasAssertion ?a ; npa:hasValidSignatureForPublicKey ?pk ; npx:introduces ?idea ; dct:created ?created .\n filter not exists { ?inv npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pk . }\n filter not exists { ?newer npx:supersedes ?np . }\n filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }\n }\n }\n }\n graph ?a { ?idea rdfs:label ?lbl . }\n optional { graph ?a { ?idea dct:description ?desc . } }\n graph npa:graph { ?np np:hasPublicationInfo ?pi . }\n optional { graph ?pi { ?np dct:creator ?prop . } }\n optional { graph ?pi { ?prop foaf:name ?pname . } }\n } group by ?idea ?np ?a ?pk ?created\n }\n optional {\n select ?idea (count(distinct ?vpk) as ?nvotes) where {\n graph ?va { ?vote a schema:VoteAction ; schema:object ?idea . }\n graph npa:graph {\n ?vnp np:hasAssertion ?va ; npa:hasValidSignatureForPublicKey ?vpk .\n filter not exists { ?vinv npx:invalidates ?vnp ; npa:hasValidSignatureForPublicKey ?vpk . }\n filter not exists { ?vnp npx:hasNanopubType npx:ExampleNanopub . }\n }\n } group by ?idea\n }\n optional {\n select ?idea (max(str(?mvnp)) as ?myvote) where {\n values ?__LOCALPUBKEY_multi {}\n graph ?mva { ?mvote a schema:VoteAction ; schema:object ?idea . }\n graph npa:graph {\n ?mvnp np:hasAssertion ?mva ; npa:hasValidSignatureForPublicKey ?mvpk .\n filter not exists { ?minv npx:invalidates ?mvnp ; npa:hasValidSignatureForPublicKey ?mvpk . }\n }\n filter(coalesce(str(?mvpk) = str(?__LOCALPUBKEY_multi), false))\n } group by ?idea\n }\n values ?__LOCALPUBKEY_multi {}\n bind(coalesce(?nvotes, 0) as ?votes)\n bind(if(bound(?propS), iri(?propS), ?propS) as ?proposer)\n bind(substr(str(?created), 1, 10) as ?date)\n bind(\"^\" as ?np_label)\n bind(if(bound(?myvote), \"\", str(?idea)) as ?upvote_target)\n bind(coalesce(?myvote, \"\") as ?withdraw_target)\n bind(if(coalesce(str(?pk) = str(?__LOCALPUBKEY_multi), false), str(?np), \"\") as ?edit_target)\n}\norder by desc(?votes) ?created" . . "Tobias Kuhn" . "2026-09-14T15:04:35Z"^^ . . . . "Get the ideas suggested for a resource with their up-votes" . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "hfBCBpROzuJ8XU5ZFF+5eZN4yUmAUhXHqajv4HXsWAOEJDQHXq5EjWHS6kUCpoaIbstKZGjhvbVBujREdolmzr03SLmwootTytRiJGfU2Ph7ImuAZlvI9+kKs2QkJ+p1nmCDw/Irp9LV0+q9pyvBph8Zvx2gz2zWr03CqBEuXcc=" . . .