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;
Replies
0Fetching replies…