Hi Patrick, thanks for your answer. XML-RPC web services (object proxy) expose OpenERP objects methods via "call" method (or maybe "execute" to be exact). It also expose the "exec_workflow" method, but I couldn't find the "query" method. Any hints about how to access "query" from web services?

Thanks Patrick for the update, will try that.

the question was if it is possible to use some kind of XML-RPC call to execute SQL, without the need to install additional software / module on the openERP server. So the answer to create a new module or write methods for existing modules is not what Yohanes is looking for....

XML-RPC is communicating with which takes and input as a XML-RPC request and process it. In OpenERP, XML-RPC is mainly working on objects and API. It's not allowing to deal with SQL. For that you have to direct deal with postgresql with help of python programming.

Thanks Dharmesh for you response. Yes actually I wanted to avoid adding custom module, but I guess it's not possible this time. Just wondering, how is the grouping in the web/gtk client (tree view) works? Was it done in the client?

How can i call a python function that executes a select query and returns a result, in my openoffice report? I mean the syntax.