تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
9545 أدوات العرض

Hi, im trying to implement a simple search function in open erp 7. It will search and list all records based on management code, but the problem is management code is a type many2one and its a field in another model. when i run it, it gives me an error like this below.What do i need to change to make it work?

ProgrammingError: operator does not exist: integer ~~* unknown LINE 1: ...t_org_table" WHERE ("budget_org_table"."management_code" ilike '%12... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts

my xml code

  <record id="feature_search" model="ir.ui.view">
        <field name="name">management.feature_inventory.search</field>
        <field name="model">management.feature_inventory</field>
        <field name="arch" type="xml">
            <search string="Feature Inventory">
        <field name="management_code" string="Management Unit Code"/>
                <field name="year" string="Year"/>
            </search>
        </field>
    </record>

my model

class feature_inventory(osv.osv):

_name = "management.feature_inventory"
_description = "Feature Inventory"
_rec_name = "feature_code"
_columns = {
    'feature_code' : fields.many2one("budget.feature_details","Code", required=True),
    'management_unit_code' : fields.many2one("budget.org_table", "Management Unit Code", required=True),
    'Total' : fields.integer("Total"),
    'condition_1' : fields.integer("Condition 1"),
    'condition_2' : fields.integer("Condition 2"),
    'condition_3' : fields.integer("Condition 3"),
    'year' : fields.integer("Year", size=64, required=True),
}
_sql_constraints = [
    ('feature_code_unique', 'UNIQUE(feature_code)', 'Each feature_code is unique.'),
]

please help...

الصورة الرمزية
إهمال

Update your xml with management_unit_code instead of management_code and try.

أفضل إجابة

In python class use table name dot notation

_name = "management.feature.inventory"

If management_code field is another module u want to show in current model. Then using related field add in the current model and then shows the field in search view.

Refer the below link to add related field

https://doc.openerp.com/6.0/developer/2_5_Objects_Fields_Methods/field_type/

الصورة الرمزية
إهمال
الكاتب

thanks...that solved the problem

المنشورات ذات الصلة الردود أدوات العرض النشاط
1
فبراير 25
4995
0
يناير 23
1479
2
مايو 22
18048
1
يناير 22
3369
4
أبريل 19
12874