OColumn with odoo functional in Odoo Mobile Framework not working

Question

I have this OColumn partner_name = new OColumn("Partner", OVarchar.class).setLocalColumn(); in my sale order model class with odoo functional method that depends on partner_id column. I would like to search the partner_name in my list using that column partner_name, but I'm a little confused on how to achieve this. Please needed some help.

This is what I've tried:

BaseFragment

  @Override
  public void onViewBind(View view, Cursor cursor, ODataRow row) {
      getPartnerIds(row);
      OControls.setText(view, R.id.partner_name,  row.getString("partner_name")); // displays false
      ....
    }
}

  private void getPartnerIds(ODataRow row){
      OValues oValues = new OValues();
      oValues.put("partner_id", row.get("partner_id"));
      saleOrder.storeManyToOne(oValues);
}

updated:

I noticed that even though I created

 @Odoo.Functional(method = "storeManyToOne", store = true, depends = {"partner_id"})
 OColumn partner_name = new OColumn("Partner", OVarchar.class).setLocalColumn();

no column was created.

Updated: partner_name column with odoo functional

Edit: Just place the 'if (type.isAssignableFrom(Odoo.Functional.class)' before the 'if (type.getDeclaringClass().isAssignableFrom(Odoo.api.class))' to have the correct values.

Answer 1

Define the partner_name field like below:

@Odoo.Functional(method="storePartnerName", store=true, depends={"partner_id"})
OColumn partner_name = new OColumn("Partner name", OVarchar.class)
                       .setLocalColumn();

public String storePartnerName(OValues values) {
    try {
        if (!values.getString("partner_id").equals("false")) {
            JSONArray partner_id = new JSONArray(values.getString("partner_id"));
            return partner_id.getString(1);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return "false";
}

You can simply get the partner_name using:

row.getString("partner_name")

EDIT:

Note that database is created when you first time run your application, or when you clean your data from app setting. You need to clean application data everytime when you update your database column.

If the column was added after the database creation, it will not be added to the corresponding table. This is because the database is not upgraded. To fix this issue you can:

• Clean application data to update your database column

• Remove user account (This will delete database) or reinstall the application to recreate the database.

• Or you can change DATABASE_VERSION in odoo/datas/OConstants then override onModelUpgrade method in sale order model and upgrade the table manually (alter sale order table and add the partner name column using SQL query: ALTER TABLE sale_order ADD partner_name VARCHAR(100)).
  When a new sale order is created and synchronized, the partner name should be computed and stored automaticaly.

  I noticed that the partner name was not set for existing records after synchrinization so I added another SQL query to compute and set the value of partner name for old records.

  Example:

    @Override
    public void onModelUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            db.execSQL("ALTER TABLE sale_order ADD partner_name VARCHAR(100)");
            db.execSQL("UPDATE sale_order SET partner_name = (SELECT name from res_partner WHERE _id=partner_id) WHERE partner_name IS NULL AND partner_id IS NOT NULL");
    }  
  

Edit (config):
using the new configuration you will get the following error (which will prevent creating fields using annotations):

W/System.err: java.lang.NullPointerException: Attempt to invoke virtual method 'boolean java.lang.Class.isAssignableFrom(java.lang.Class)' on a null object reference
W/System.err:     at com.odoo.core.orm.OModel.compatibleField(OModel.java:349)

CODE:

if (type.getDeclaringClass().isAssignableFrom(Odoo.api.class)) {

Try to remove .getDeclaringClass()

Edit: not all partner names are shown

There is a org.json.JSONException error that happens when it try to convert partner_id string to a JSON array.

W/System.err: org.json.JSONException: Unterminated array at character 12 of [114.0, UH PARTNER]

The error happens when it try to convert names containing spaces. To avoid that you can cast partner_id string to a list of objects.

In partnerName method, replace the following code:

JSONArray partner_id = new JSONArray(values.getString("partner_id"));
return partner_id.getString(1);

With:

List<Object> partner_id = (ArrayList<Object>) values.get("partner_id");
return partner_id.get(1) + "";