Hi Devs
I would like some more eyes on my query. It is not producing the SQL I
expect.
Working with OG for D7, I am looking to select all the group users with a
specific state. I would have expected this code to do what I wanted, but, it
does not.
I have attached the code and sql below. The SQL is the result of running the
query on gid = 2 and states = 1. When run, I am getting results for both
states 1 and 3.
Anyone got any more insight ?
Thanks very much
Peter
<code>
$query = new EntityFieldQuery;
$query
->entityCondition('entity_type', 'user')
->fieldCondition('group_audience', 'gid', $gid)
->fieldCondition('group_audience', 'state', (array) $states, 'IN');
</code>
<sql>
SELECT DISTINCT field_data_group_audience0.entity_type AS entity_type,
field_data_group_audience0.entity_id AS entity_id,
field_data_group_audience0.revision_id AS revision_id,
field_data_group_audience0.bundle AS bundle
FROM field_data_group_audience field_data_group_audience0
INNER JOIN field_data_group_audience field_data_group_audience1 ON
field_data_group_audience1.entity_type =
field_data_group_audience0.entity_type
AND field_data_group_audience1.entity_id =
field_data_group_audience0.entity_id
WHERE
( field_data_group_audience0.group_audience_gid = '2' ) AND
(field_data_group_audience1.group_audience_state IN ('1'))
AND ( field_data_group_audience0.deleted = '0' ) AND (
field_data_group_audience0.entity_type = 'user' ) LIMIT 0 , 30
</sql>
The output (slightly modified to add state), gives me this:
entity_type state entity_id revision_id bundle user 1 1 1 user user 3 2
2 user
Not sure if the formatting will hold, but, due to the joins, I am getting
both states 1 and 3.
