Closed (won't fix)
Project:
Voting API
Version:
master
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
4 May 2007 at 19:49 UTC
Updated:
11 Jan 2011 at 16:42 UTC
Hello,
I'm not good at this. Just spent a full day trying to figure this out and I can't. Any help would be greatly appreciated.
I'm using votingapi through voteupdown. So nodes have votes of +1 or -1. I'm trying to write a query that would display the number of +1 votes and the number of -1 votes for the specific node displayed. So something like:
"This node has 7 positive votes and 3 negative votes."
I think I need to do a SUM on votingapi_votes.value WHERE value = 1 (or -1) but can't figure how to just display the sum for the current node (nid). Maybe something where v.content_id = n.nid???
How to connect those? Or limit to current nid?
Thanks for any advice.
Comments
Comment #1
eaton commentedThe 4.7 branch (which this issue was posted against) is no longer supported.