Skip to Content
Menu
This question has been flagged
1 Atsakyti
5445 Rodiniai

I need to make in the python code a search for records and it should show me all records between two dates.


start_date between 15:00 and 15:30

end_date between 15:00 and 15:30


and it should show me all record that matches this filter


I need it to do in python with the .search method:

self.env['mrp.workorder'].search([]) 


any help? thank you 

Portretas
Atmesti
Best Answer

Hi Wizardz,

You can add new boolean compute field with store=True and depends on start_date and end_date.

In compute method you can check the time of start and end date if it between 15:00 to 15:30, set boolean field value true.

Then use that field in the search method.

Regards,

Hemangi.

Portretas
Atmesti
Autorius

I don't know how I can filter it inside the .search method.

Related Posts Replies Rodiniai Veikla
2
geg. 25
844
2
saus. 23
13832
1
gruod. 20
21235
22
gruod. 23
49460
2
lapkr. 23
3135