[solved] Chained api get call ignores arguments

[andersiversen]

Hello

I'm using the following chained api call:

Code: [Select]

civicrm_api("Contact","get", array ('version' => 3,'sequential' => '1', 'contact_sub_type' => 'Student', 'api.groupContact.get' => array('group_id' => 4, 'status' => 'Added')));
I would think that it should return only students in group 4, but it ignores the 'group_id' argument and returns a result like:

Code: [Select]

...
            [4] => Array
                (
                    [contact_id] => 25660
                    [contact_type] => Individual
                    [contact_sub_type] => Array
                        (
                            [0] => Student
                        )

                    [sort_name] => Lastname, Mathilde
                    [display_name] => Mathilde Lastname
                    [do_not_email] => 0
...
                    [id] => 25660
                    [api.groupContact.get] => Array
                        (
                            [is_error] => 0
                            [version] => 3
                            [count] => 2
                            [values] => Array
                                (
                                    [0] => Array
                                        (
                                            [id] => 91514
                                            [group_id] => 2
                                            [title] => Some group title
                                            [visibility] => User and User Admin Only
                                            [is_hidden] => 0
                                            [in_date] => 2014-11-06 10:06:46
                                            [in_method] => API
                                        )

                                    [1] => Array
                                        (
                                            [id] => 88432
                                            [group_id] => 10
                                            [title] => Some other group title
                                            [visibility] => Public Pages
                                            [is_hidden] => 0
                                            [in_date] => 2014-11-04 09:54:01
                                            [in_method] => API
                                        )

                                )

                        )

                )

Is this as it should be? (this is on a civicrm 4.4 installation)

If I switch the contact get call and group get call, so I do it the other way around (the contact get is nested inside the group get), it would probably do what I want. But that's only in my unique case here, because I don't really have any contacts in group 4 who aren't students.

[Coleman Watts]

What chaining does is to first fetch results from the outer query (ignoring chaining) and then it goes back through the results and fetches the results of the chained api action for each one.
So I think it is working correctly and you are trying to make chaining do something it wasn't intended for, which is to set additional filters on the outer results.
If you really want to fetch all students in group 4, try this:

Code: [Select]

civicrm_api3("Contact","get", array ('contact_sub_type' => 'Student', 'group' => 4));

[andersiversen]

That works perfectly - thanks Coleman!

For reference:
If I go to the api explorer and choose entity Contact and action getfields, I see all the fields that I can use with a contact get call (I guess). But I don't see "group" as one of them.
- where do I see a complete list of all the fields I can use in a contact get call, including the fields which aren't in the contact table in the database (eg group - and email is another example) ?

[Coleman Watts]

I can see those fields in the api explorer with the newest version (4.6)