Tutorial search partners in openerp - nopri/sqliteboy GitHub Wiki

Tutorial: Search partners in OpenERP

In this tutorial, we will search for partners in OpenERP, output to SQLiteBoy report.

Please note that extended features must be activated.

(Tested: OpenERP 6.1.1 / Windows 7 32-bit)

  1. Create report: search_partner
    • report name: search_partner
    • code:
{
  "title" : "Search Partner",
  "header": ["id", "name"],
  "sql"   : "select 1",
  "data"  : [
              {
                "key"       : "name"
              }
               ],
  "security" : {
                 "run" : ""
               }
}
  1. Create sqliteboy_user.py file (if not exists) in current working directory. We are using python handler to talk to OpenERP server. Please add the following function:
def report_search_partner(user, db, parsed, form_data, data):
    import xmlrpclib
    #
    #please edit
    server = 'http://localhost:8069'
    server_common = '%s/xmlrpc/common' %(server)
    server_object = '%s/xmlrpc/object' %(server)
    user = 'admin'
    password = 'admin'
    db = 'test1'
    #
    #
    sock_common = xmlrpclib.ServerProxy(server_common)
    uid = sock_common.login(db, user, password)
    #
    sock_object = xmlrpclib.ServerProxy(server_object)
    fields = form_data[0]
    fields_name = fields.get('name')
    #
    search_q = [('name', 'ilike', '%%%s%%' %(fields_name))]
    search_i = sock_object.execute(
                db, 
                uid, 
                password,
                'res.partner',
                'search',
                search_q
    )
    #
    search_f = ['name']
    search_r = sock_object.execute(
                db,
                uid,
                password,
                'res.partner',
                'read',
                search_i,
                search_f
    )
    #
    return search_r
⚠️ **GitHub.com Fallback** ⚠️