Hello!
I need to do a simple thing, but didn't find the solution.
I have:
node type:review with cck:emotion(allowed values: cool, warm) can be posted in group.
I need to show how many cool/warm reviews in current group.

I did:

Views block:
Argument: Node: Nid -> default value -> Current group node from context

Field: OG Statistics: Group Statistic: Posts Count
This works fine but reveals number of all nodes of any content types in group

Problem comes with filtering
Filter: Content: Review type (field_review_type) - Allowed values
get empty request

SELECT DISTINCT(node.nid) AS nid,
   og_statistics.posts_count AS og_statistics_posts_count
 FROM node node 
 INNER JOIN content_type_review node_data_field_review_type ON node.vid = node_data_field_review_type.vid
 LEFT JOIN og_uid og_uid ON node.nid = og_uid.nid
 LEFT JOIN og_statistics og_statistics ON node.nid = og_statistics.nid
 WHERE (node_data_field_review_type.field_review_type_value IN ('<img src=\'/i/cool.png\'> <span>Cool</span>')) AND (og_uid.nid = 157)
 GROUP BY nid

Should i use Organic Group Statistics at all?
Sorry for my english!

Comments

hefox’s picture

Status: Active » Fixed

Not maintainer, but no, this is not the use case of OG statistics as far as I can tell.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.