İçereği Atla
Bu soru işaretlendi
filterdatesearchworkorderbetween
1 Cevapla
5460 Görünümler
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
Vazgeç
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
En İyi Yanıt

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
Vazgeç
wizardz
Üretici

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

İlgili Gönderiler Cevaplar Görünümler Aktivite
Problem with date filter BETWEEN two dates
filter date between v18
Avatar
Avatar
Avatar
2
May 25
850
how get date from datetime field in domain of search view? Çözüldü
filter date search datetime
Avatar
Avatar
Avatar
2
Oca 23
13841
How to filter by dates (date between two dates)
filter date search domain_filter
Avatar
Avatar
1
Ara 20
21239
Search within a period of date Çözüldü
filter date v7 search
Avatar
Avatar
Avatar
Avatar
22
Ara 23
49465
how can i create a filter that uses the "and" condition
filter search
Avatar
Avatar
Avatar
2
Kas 23
3141