Closed (fixed)
Project:
Organic Group Statistics
Version:
6.x-1.0-rc5
Component:
Documentation
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
18 Aug 2011 at 13:55 UTC
Updated:
20 Apr 2012 at 20:51 UTC
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
Comment #1
hefox commentedNot maintainer, but no, this is not the use case of OG statistics as far as I can tell.