views

By Bill Seremetis, 25 November, 2014

I needed to create a list with the total count of flags, for a specific flag type, made by users. The query to do this for one user is this:
SELECT COUNT(*) FROM flagging WHERE uid=[user_id] AND fid=[flag_id];

Doing this with views, while not very difficult is a bit trivial. You need to start with a node view and not with a user view. From here on things go as follows: