CiviCRM Community Forums (archive)

Is there any way to do an API call with parameters that are "OR"? I would like to return only groups that have parents X or Y or Z.

More specifically, I want to do this with the entityRef. I've created an entityRef that is limited to groups. I want to take it a step further and only show groups that have a specific parent (where there are multiple parents that I want children from).

Is there any way to do this?

More detail: I have groups for each day of the week that are parents of small groups that are on that specific day. I'm using the entityRef to look up the small groups so that I can add a contact to the group. I want to keep the list limited to only small groups in order to keep it clean. 

Example group structure:
Wednesday
- Small Group 1
- Small Group 2
Thursday
- Small Group 3
- Small Group 4

I want the entityRef to only list Small Group 1-4.

As a quick fix I've been able to filter based on:
'title'  => array('LIKE' => "%Small Group%")

I'm adding my entity to a form with the following code:
$this->addEntityRef('field_smallGroupGroup', ts('Select Small Group'), array(
            'api' => array(
                'params' => array(
               'parents' => 34, // this is one of the several parents I want children returned from
                )),
            'create' => FALSE,
            'entity' => 'group',
            TRUE)
        );

Coleman,

That is pretty cool! EntityRef is great . Thanks for implementing it!

I have never used the "IN" operator. Is there a specific format I need to set the value as? In the API Explorer setting "Group IDs IN 29" does not return any results. Whereas "Group IDs = 29" returns 7 results.

Hey cool, you're the first 3rd party developer I've heard of who is using my new EntityRef code
(I'm not counting CiviVolunteer and CiviHR but maybe technically they were first)
Anyway, have you tried exploring it in the api explorer? It provides a choice of operators for each field, I think you want to use the IN operator.

That works like a charm. Thanks a ton for this help. This is going to help me in a lot of other ways. I always thought it wasn't possible to do this sort of thing!

Any ideas why I can't get this to work? I just get the error

    [message] => IN is not of the type Integer

Here's my code -

   $result = civicrm_api3('Contribution', 'get', array(
    'sequential' => 1,
    'financial_type_id' => array('IN' => array(1,2)),
    'options' => array (
      'limit' => 5,
      'sort' => 'receive_date ASC' // Sets sort order
      ),
    ));

So is there any way to have multiple values for a parameter right now?