RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Post
Remote status
Context
11RT: https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93
Yes, I vooted
how many votes does NCD show for the OP poll on the normal front end (or pleromaFE)
select distinct data->>'actor' as actor_id, data->>'name' as vote from objects where data->>'inReplyTo' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93' and data->>'type' = 'Answer' order by vote asc;
11 votes total. 5 no, 6 yes.
okay thank you so much
Of course! Let me know if there’s anything else I can do.
I'm wondering if I can deliver votes over our relay
A relay could be used, but that isn't universal. When you look at the Object as returned by netzsphaere.xyz, it already has a "voters" array with all the voters, but it is incorrect. I'm not in it for example. So this is processing issue, rather than a federation issue probably. Pleroma should also use the array to get the accurate number of voters, which it seemingly currently does not.
curl -H "Accept: application/activity+json" "https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93" | jq .voters
cc @snacks Could you do a DB query for the answers to the test poll? You should have all the Answer Objects.
select distinct data->>'actor' as actor_id, data->>'name' as vote from objects where data->>'inReplyTo' = 'https://netzsphaere.xyz/objects/fbe413fa-dd74-46b3-860c-7df21d395e93' and data->>'type' = 'Answer' order by vote asc;
@phnt @georgia @matty @graf i assume no one has any issues with me just dumping who voted what in a test poll
actor_id | vote
----------------------------------------------------+------
https://decayable.ink/users/Folklore | no.
https://detroitriotcity.com/users/Spooke | no.
https://gameliberty.club/users/Mr_NutterButter | no.
https://jollyville.net/users/not_br549 | no.
https://noauthority.social/users/Vo | no.
https://shitposter.world/users/shibao | no.
https://snug.moe/users/97re3zgzsp | no.
https://brain.worm.pink/users/technicallydifficult | yes!
https://detroitriotcity.com/users/TrueMasterCole | yes!
https://fsebugoutzone.org/users/npc | yes!
https://mai.waifuism.life/users/9otxaeemjqy70001 | yes!
https://mrhands.horse/users/shitpisscum | yes!
https://netzsphaere.xyz/users/snacks | yes!
https://pisskey.io/users/963omd7apj | yes!
https://pleroma.soykaf.com/users/kaia | yes!
https://poa.st/users/cute | yes!
https://shigusegubu.club/users/hj | yes!
https://shitposter.world/users/sun | yes!
https://social.linux.pizza/users/trogluur | yes!
https://spinster.xyz/users/Flick | yes!
https://stereophonic.space/users/echo | yes!
https://stereophonic.space/users/genmaicha | yes!
https://stereophonic.space/users/scathach | yes!
The only poast user is cute despite us having 86 in our database. thats wild
Replies
0Fetching replies…