Skip to Content
Dette spørgsmål er blevet anmeldt
filterdatesearchworkorderbetween
1 Svar
5455 Visninger
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
Kassér
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Bedste svar

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
Kassér
wizardz
Forfatter

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

Related Posts Besvarelser Visninger Aktivitet
Problem with date filter BETWEEN two dates
filter date between v18
Avatar
Avatar
Avatar
2
maj 25
847
how get date from datetime field in domain of search view? Løst
filter date search datetime
Avatar
Avatar
Avatar
2
jan. 23
13835
How to filter by dates (date between two dates)
filter date search domain_filter
Avatar
Avatar
1
dec. 20
21236
Search within a period of date Løst
filter date v7 search
Avatar
Avatar
Avatar
Avatar
22
dec. 23
49463
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
nov. 23
3140