This question has been flagged
2 Replies
8300 Views
v7many2many
Avatar
Joeri Belis

I want to search all res_users that belong to a certain res_company via xml-rpc. The test client is written in .net env. When i keep the search query simple like searching on the "login" field = 'login_name_x' this works fine.

            String[] condition = new String[] { "login", "=", "name_x" };
            ArrayList lstFilters = new ArrayList();
            lstFilters.Add(condition);
            Object[] resSearch = openERPproxy.search(dbname, userID, pwd,res.users",search", lstFilters.ToArray());

But i need to filter on de company_ids where a res_users records belongs to. So i tried following filter as i know there are res_users in company_id 3

            String[] condition = new String[] { "company_ids", "=", "3" };

But this is not a working solution because it returns nothing?!

What is the correct approach to get xml-rpc do search filter on the many2xxx fields?

Avatar
Discard
Avatar
Naresh Soni (nch)
Best Answer

Hello Joeri,

use String[] condition = new String[] { "company_ids", "in", [3] };

Thanks,

Avatar
Discard
Joeri Belis
Author

[3] is not working, it needs to be a string. but no success yet

Naresh Soni (nch)

Joeri, not sure how do you write a list([]) in .net but OpenERP will expect a list here as company_ids is a Many2many

Avatar
Martin
Best Answer

You can find some examples of XMLRPC usage here ...

https://gist.github.com/t3dev/3016471

... and here ...

GData_OpenERP_Data_Pump

Avatar
Discard