. . . . "Returns the assertion templates created by the given user. Supports both template identity shapes: for templates with embedded identity (anchored via the npx:embeds triple), the label, tags, and publish link are based on the embedded template node (the IRI external references should carry); for legacy templates, the nanopub URI is used and the node is the assertion graph URI. Multiple tags are concatenated into one multi-value column, and dual labels collapse to one (untagged-language label preferred). Governed versions are deduplicated within the user's own output: of the user's non-invalidated versions declaring the same dct:isVersionOf plus gen:governedBy pair, only the newest is listed (no space-membership check, as the list reflects what the user created; the winners are materialized once in a single-row group_concat sub-select sharing no variables with the outer query)." . . . "Get templates by given user" . . "prefix rdfs: \nprefix dct: \nprefix np: \nprefix npa: \nprefix npx: \nprefix nt: \nprefix gen: \n\nselect (concat(\"\", coalesce(min(?ulabel), min(?anylabel)), \"\") as ?label) (group_concat(distinct replace(replace(str(?tag), \"\\\\\\\\\", \"\\\\\\\\\\\\\\\\\"), \"[\\r\\n]+\", \"\\\\\\\\n\"); separator=\"\\n\") as ?tags_multi) ?date ?np (\"^\" as ?np_label) where {\n {\n select (group_concat(?w1; separator=\"|\") as ?winners) where {\n {\n select ?gKind ?gSpace (max(concat(str(?gDate), \">\", str(?gNp))) as ?maxW) where {\n graph npa:graph {\n ?gNp npx:signedBy ?_user_iri ;\n npa:hasValidSignatureForPublicKey ?gPubkey ;\n dct:created ?gDate ;\n npx:embeds ?gVersion ;\n np:hasAssertion ?gA .\n filter not exists { ?gInv npx:invalidates ?gNp ; npa:hasValidSignatureForPublicKey ?gPubkey . }\n }\n graph ?gA { ?gVersion dct:isVersionOf ?gKind ; gen:governedBy ?gSpace . }\n } group by ?gKind ?gSpace\n }\n bind(concat(str(?gKind), \">\", str(?gSpace), \">\", ?maxW) as ?w1)\n }\n }\n graph npa:graph {\n ?np npx:signedBy ?_user_iri .\n ?np npa:hasValidSignatureForPublicKey ?pubkey .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }\n ?np npx:hasNanopubType nt:AssertionTemplate .\n ?np dct:created ?date .\n ?np np:hasAssertion ?a .\n }\n optional {\n graph npa:graph { ?np npx:embeds ?tnode . }\n graph ?a { ?tnode a nt:AssertionTemplate . }\n }\n bind(coalesce(?tnode, ?a) as ?t)\n bind(if(?t = ?a, ?np, ?t) as ?template_iri)\n graph ?a { ?t rdfs:label ?anylabel . }\n optional { graph ?a { ?t rdfs:label ?ulabel . filter(lang(?ulabel) = \"\") } }\n optional { graph ?a { ?t nt:hasTag ?tag . } }\n filter not exists { graph ?a { ?t a nt:UnlistedTemplate } }\n optional { graph ?a { ?t dct:isVersionOf ?kind ; gen:governedBy ?space . } }\n bind(concat(\"|\", coalesce(?winners, \"\"), \"|\") as ?wlist)\n filter( !bound(?kind)\n || !contains(?wlist, concat(\"|\", str(?kind), \">\", str(?space), \">\"))\n || contains(?wlist, concat(\"|\", str(?kind), \">\", str(?space), \">\", str(?date), \">\", str(?np), \"|\")) )\n} group by ?template_iri ?date ?np\norder by desc(?date)" . . "Tobias Kuhn" . "2026-07-09T17:40:51Z"^^ . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "pk0C5X4uzRwEtg7FfgarsgXQsl/TxjWFdCRAIrlJCovjF/p+w9z7G+vy06sYEBVEozE+7sIrxFk2UTdGVa0tkxSbo7mtPR6K/CtSWjiERIBWUtC112LD43dXTacPPNA4MxzpGYVI/90DdrFOM/pFYcehdbFW9aUFNE04F0kSfKk=" . . .