Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
filterdatesearchworkorderbetween
1 Besvara
7156 Vyer
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
Avbryt
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Bästa 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
Avbryt
wizardz
Författare

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

Relaterade inlägg Svar Vyer Verksamhet
Problem with date filter BETWEEN two dates
filter date between v18
Avatar
Avatar
Avatar
2
maj 25
3113
how get date from datetime field in domain of search view? Löst
filter date search datetime
Avatar
Avatar
Avatar
2
jan. 23
15814
How to filter by dates (date between two dates)
filter date search domain_filter
Avatar
Avatar
1
dec. 20
23122
Search within a period of date Löst
filter date v7 search
Avatar
Avatar
Avatar
Avatar
22
dec. 23
51847
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
nov. 23
5004