. . . . "Returns all 3PFF events for a given user, including the role they had in each event." . . . "Get 3PFF events for user" . . "prefix rdfs: \r\nprefix np: \r\nprefix npa: \r\nprefix npx: \r\nprefix dct: \r\nprefix tpff: \r\nprefix schema: \r\n\r\nselect ?event ?event_label (sample(?ev_name) as ?event_name) (sample(?ev_date) as ?event_date) ?roles_multi_iri ?roles_label_multi ?np_multi_iri ?np_label_multi where {\r\n {\r\n select ?event (replace(str(?event), \"^.*/\", \"\") as ?event_label) (group_concat(str(?role); separator=\" \") as ?roles_multi_iri) (group_concat(?role_label; separator=\"\\n\") as ?roles_label_multi) (group_concat(str(?latest_np); separator=\" \") as ?np_multi_iri) (group_concat(\"^\"; separator=\"\\n\") as ?np_label_multi) where {\r\n {\r\n select ?event ?role ?role_label (sample(?np) as ?latest_np) where {\r\n values (?role ?role_label) {\r\n (tpff:participatedAsParticipantIn \"Participant\")\r\n (tpff:participatedAsFacilitatorIn \"Facilitator\")\r\n (tpff:participatedAsTrainerIn \"Trainer\")\r\n (tpff:participatedAsFacilitatorAssistantIn \"Facilitator Assistant\")\r\n (tpff:participatedAsTrainerAssistantIn \"Trainer Assistant\")\r\n (tpff:participatedAsImplementerIn \"Implementer\")\r\n (tpff:participatedAsImplementerAspirantIn \"Implementer Aspirant\")\r\n }\r\n graph npa:graph {\r\n ?np npx:hasNanopubType ?role .\r\n ?np dct:creator ?_user_iri .\r\n ?np npa:hasValidSignatureForPublicKeyHash ?pk .\r\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pk . }\r\n ?np np:hasAssertion ?a .\r\n ?np dct:created ?date .\r\n }\r\n graph ?a {\r\n ?_user_iri ?role ?event .\r\n }\r\n filter not exists {\r\n graph npa:graph {\r\n ?np2 npx:hasNanopubType ?role .\r\n ?np2 dct:creator ?_user_iri .\r\n ?np2 npa:hasValidSignatureForPublicKeyHash ?pk2 .\r\n filter not exists { ?npx2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pk2 . }\r\n ?np2 np:hasAssertion ?a2 .\r\n ?np2 dct:created ?date2 .\r\n filter(?date2 > ?date)\r\n }\r\n graph ?a2 {\r\n ?_user_iri ?role ?event .\r\n }\r\n }\r\n }\r\n group by ?event ?role ?role_label\r\n }\r\n }\r\n group by ?event\r\n }\r\n graph npa:graph {\r\n ?enp npx:introduces ?event .\r\n ?enp npa:hasValidSignatureForPublicKeyHash ?epk .\r\n filter not exists { ?enpx npx:invalidates ?enp ; npa:hasValidSignatureForPublicKeyHash ?epk . }\r\n ?enp np:hasAssertion ?ea .\r\n }\r\n graph ?ea {\r\n ?event a tpff:3PFF-event .\r\n ?event rdfs:label ?ename .\r\n optional { ?event dct:date ?dateDct . }\r\n optional { ?event schema:startDate ?dateSchema . }\r\n }\r\n bind(coalesce(?dateDct, strBefore(str(?dateSchema), \"T\")) as ?ev_date)\r\n bind(replace(?ename, \"^[^|]*\\\\| ?\", \"\") as ?ev_name)\r\n}\r\ngroup by ?event ?event_label ?roles_multi_iri ?roles_label_multi ?np_multi_iri ?np_label_multi\r\norder by desc(sample(?ev_date))" . . "Tobias Kuhn" . "2026-04-07T16:27:22.879+02:00"^^ . . . . . . . . . . . "RSA" . "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" . "Rv23ka6Iap2ZlUrqxYkpBJsJ7LlYxqIOsgD9FeOMBuQXvGolJgdJZ53PVuEQ04xzA/YMVT1p6ClhShdBiC3agelhbW421GsrQ6lXK4BGcOi2U8bV/p6Fv1GghYa44q/AK4O7KLq3y4rvO2xpycAEHuEbb+jK89CMzMUz5i7OHe8=" . . .