Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
filterdatesearchworkorderbetween
1 Odpovědět
5457 Zobrazení
Avatar
wizardz

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 

Avatar
Zrušit
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Nejlepší odpověď

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.

Avatar
Zrušit
wizardz
Autor

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

Related Posts Odpovědi Zobrazení Aktivita
Problem with date filter BETWEEN two dates
filter date between v18
Avatar
Avatar
Avatar
2
kvě 25
848
how get date from datetime field in domain of search view? Vyřešeno
filter date search datetime
Avatar
Avatar
Avatar
2
led 23
13841
How to filter by dates (date between two dates)
filter date search domain_filter
Avatar
Avatar
1
pro 20
21236
Search within a period of date Vyřešeno
filter date v7 search
Avatar
Avatar
Avatar
Avatar
22
pro 23
49463
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
lis 23
3141