Skip to Content
This question has been flagged
domainviewdomain_filterodoo9
1 Respondre
17484 Vistes
Avatar
Baintex Technologies S.L.

I want to filter a domain with a function instead of a variable in order to show only some registers in the view.

I have done this:

 

 class SaleOrderExt(models.Model):
  _inherit = ['sale.order']
  @api.multi
  def custom_funct_date(self):
   my_date = ... (some stuff)
   return my_date

Then, in the view, I have filtered the domain:

 

    <?xml version="1.0"?>
    <openerp>
      <data>
        <record id='action_menu_custom_date' model='ir.actions.act_window'>
          <field name="name">This is a test</field>
          <field name="res_model">sale.order</field>
          <field name="view_type">form</field>
          <field name="view_mode">tree,form</field>
          <field name="domain">[('date_order','>=',custom_funct_date)]</field>
        </record>
      </data>
    </openerp>

But this is giving me an error: 

    ValueError: "name 'custom_funct_date' is not defined" while evaluating
    u"[('date_order','>=',custom_funct_date)]"
Avatar
Descartar
Avatar
Divya-vyas
Best Answer

Hello

I suggest you to add one more field which is compute field. and then pass in domain. use custom_funct_date method in that new compute field.


Avatar
Descartar
Baintex Technologies S.L.
Autor

Okay, I have tried this too: my_date = fields.Datetime(string="Computed date", compute="custom_funct_date")

But it gives me that error: ValueError: "name 'my_date' is not defined" while evaluating u"[('date_order','>=', my_date)]"

Divya-vyas

it's wrong syntax.

try this one.

"[('date_order','>=', 'my_date')]"

Divya-vyas

also add my_date on view file and set invisible = 1

Baintex Technologies S.L.
Autor

DataError: invalid input syntax for type timestamp: "my_date"

LÍNEA 1: ...ids"."res_id") AND (("sale_order"."date_order" >= 'my_date...

Divya-vyas

did you add field in form view?

Baintex Technologies S.L.
Autor

I think so. In my custom view, the field appears (if I quit the part of invisible).

Divya-vyas

make sure your compute function return proper date format like sale_order.date_order,

try also without ('date_order','>=', my_date)

Divya-vyas

*with ('date_order','>=', my_date)

Baintex Technologies S.L.
Autor

Checked and same result :(

Baintex Technologies S.L.
Autor

I think that if I put this:

('date_order','>=', my_date)

my_date is treated as a variable, and that variable doesn't exist.

If I put:

('date_order','>=', 'my_date')

'my_date' is treated as a string, and gives an error, because a string doen't have a datetime type

salah BELHAMICHE

Any solution For this problem ? i have the same use case.

Related Posts Respostes Vistes Activitat
How can I pass more than one field to a search function? In Odoo 9 Solved
domain view search domain_filter odoo9
Avatar
Avatar
Avatar
Avatar
6
de set. 20
20765
Condition Drop Down Items
domain domain_filter
Avatar
0
de febr. 25
18
[odoo 11] A problem of domain as strings on xml file Solved
domain view
Avatar
Avatar
Avatar
2
de maig 18
5221
How can I use domain filter with a function to hide lines in a treeview in odoo 9?
filter domain domain_filter function_field odoo9
Avatar
Avatar
Avatar
2
de set. 16
8655
how to access another models fields from view (xml) file
domain view
Avatar
Avatar
Avatar
2
de març 15
13461