Reading values from Row object

[bwilmus]

Hi,

I try to get some values from a Row object:

ObjectAdapter objectAd = openERPSession.getObjectAdapter("product.template");
filters.add("default_code","=", String.valueOf(default_code));
String[] tuple = new String[]{"id","name", "event_type_id"};
RowCollection products = objectAd.searchAndReadObject(filters, tuple);

if (products.isEmpty()){
logError("Errorr product not found");
setErrors(1);
return false;
}else{
Row product = (Row) products.get(0);
Integer product_id = product.getID();
Integer event_type_id = product.get("event_type_id"); // Line 44
}

This code returns me the following error:
Line 44, Column 14: Assignment conversion not possible from type "java.lang.Object" to type "java.lang.Integer"

So I have tried:
Integer event_type_id = product.get("event_type_id").getValue();
No luck...

So I decided to refer to the wiki example with the following code:
for (Row row : products){
Integer product_id = row.getID();
Integer event_type_id = row.get("event_type_id");
}

This code returns me the following error:
Line 46, Column 22: Operator ";" expected
Line 46 is the for (Row row : products) statement. It seems that Java was expecting some iterator there.

Please help, I really need that working fast...

[flotho]

try something like this :

Object[] propertyIdName = (Object[])row.get(property);

[flotho]

/**
* Get id of a Many2One property of an object row. Static method.
*
* @param row object row
* @param property should be something like "xxx_id"
* @return propertyId the id of the property
*/
public static Integer getMany2OneId(final Row row, final String property) {
if (row != null && property != null) {
Object[] propertyIdName = (Object[])row.get(property);
// propertyIdName[0] = id of Many2One linked object
// propertyIdName[1] = name of Many2One linked object
return (propertyIdName == null ? null : (Integer)propertyIdName[0]);
}
return null;
}

[bwilmus]

Ok for a Many2One object.
I did modify my code to:

Object[] event_type_obj = (Object[])product.get("event_type_id");
Integer event_type_id = (Integer) event_type_obj[0];

and it works now.

But what about
String product_name = product.get("name");

Why is product.get("name") an object and how to get the product name from it?

[bwilmus]

Maybe the product name is an object because of translation but I have tried also that one:
default_code = product.get("default_code");
and product.get("default_code") is also an object.

I feel that something is missing in the wiki about the way we should read Odoo object attributes.