Technical mailing list archives

technical@mail.odoo.com

Avatar

Re: Filter last 23 hours data

by
Technogeo Soft Solution Pvt. Ltd, Saurav Kumar
- 02/07/2018 08:22:49
Omprakash

Skype or whatsapp me i will connect you. 

Thanks 

On 02-Jul-2018 5:18 PM, "Omprakash Maurya" <opmaurya111@gmail.com> wrote:
Dear Saurav,

Thanks, but i have no contact details him.

On Mon, Jul 2, 2018 at 1:39 AM, Saurav Kumar <saurav@geotechnosoft.com> wrote:
Maurya;

My friend you should call Sonu or Ajeet buddy and you can get your problem solved in few minutes.


Thanks

On 1 Jul 2018 22:29, "Omprakash Maurya" <opmaurya111@gmail.com> wrote:
Dear Matt,

I try and also remove round bracket "(" on context_today()

On Sun, Jul 1, 2018 at 6:54 PM, Matt Taylor <matt454357@gmail.com> wrote:
Add another round bracket ")" before the last square bracket "]".

Matt


On Thu, Jun 28, 2018, 11:17 PM Omprakash Maurya <opmaurya111@gmail.com> wrote:
Dear  Gandhi,

both code throwing error
Error: Failed to evaluate search criterions: 
{"code":400,"message":"Evaluation Error","data":{"type":"local_exception","debug":"Local evaluation failure\nExpected \")\", got \"]\"\n\n{\"domains\":[[],\"[('assign_date','>=', (context_today() - datetime.timedelta(days=1)).strftime('%Y-%m-%d') ), ('assign_date','<=', (context_today())]\"],\"contexts\":[{\"lang\":\"en_US\",\"tz\":\"Asia/Calcutta\",\"uid\":1,\"params\":{\"action\":547,\"min\":1,\"limit\":80,\"view_type\":\"list\",\"model\":\"website.support.ticket\",\"_push_me\":false},\"search_default_today\":1},{}],\"group_by_seq\":[]}"}}


On Thu, Jun 28, 2018 at 7:38 PM, GHANDI Othmane <othmane.ghandi@gmail.com> wrote:
Hi

you can use this code (Something like this) in your Search Form

<filter name="last_23hours" string="Last 23 Hours" domain="[('assign_date','&gt;=', (context_today() - datetime.timedelta(days=1)).strftime('%%Y-%%m-%%d') ), 
('assign_date','&lt;=', (context_today())]"/>

Or
<filter name="last_23hours" string="Last 23 Hours" domain="[('assign_date','&gt;=', (context_today() - datetime.timedelta(hours=23)).strftime('%%Y-%%m-%%d') ), 
('assign_date','&lt;=', (context_today())]"/>

Hope it will help
​Good Luck​

Othmane Ghandi
----------------------------------------------------------------------------------------------------------------------------------------------
''Where others see limitations, we see possibilities''
"les bonnes choses viennent à ceux qui savent attendre. Les grandes choses viennent à ceux qui se lèvent et qui font tout pour y arriver"
-----------------------------------------------------------------------------------------------------------------------------------------------
          http://www.viadeo.com/profile/0021ck3b96kz2yq4                                          
: othmane.ghandi
: +212 6 00 45 96 84


Le jeu. 28 juin 2018 à 14:24, iWesabe <odoo@iwesabe.com> a écrit :

Have a look on this link ...

https://www.odoo.com/forum/help-1/question/how-filter-last-week-44899

Thanks & Regards
-------------
Shameem Babu P K
Odoo Technical Consultant
______________________________
GLOBAL CREATIVE CONCEPTS TECH CO LTD
Kingdom of Saudi Arabia
E  : odoo@iwesabe.com
Ph : +966 13 895 6600; Ext:222
Mob: +966 539 079 660
Web: www.iwesabe.com
___________________
On 06/28/2018 04:11 PM, Omprakash Maurya wrote:
Hi iwesabe,

I have a custom fields assign_date type datetime and i want to filter base on this. Last 23 hours assigned date data.

On Thu, Jun 28, 2018 at 6:33 PM, iWesabe <odoo@iwesabe.com> wrote:


You can use create_date field of sale.order.

Thanks & Regards
-------------
Shameem Babu P K
Odoo Technical Consultant
______________________________
GLOBAL CREATIVE CONCEPTS TECH CO LTD
Kingdom of Saudi Arabia
E  : odoo@iwesabe.com
Ph : +966 13 895 6600; Ext:222
Mob: +966 539 079 660
Web: www.iwesabe.com
___________________
On 06/28/2018 03:56 PM, Omprakash Maurya wrote:
Dear Team,

How can i filter last 23 hours data on sale order.

--
Thanks & Regards

OM Prakash Maurya

ERP Developer & Managing


+918233142254 | Skype : opmaurya96

www.maurysolutions.com



_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Thanks & Regards

OM Prakash Maurya

ERP Developer & Managing


+918233142254 | Skype : opmaurya96

www.maurysolutions.com



_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Thanks & Regards

OM Prakash Maurya

ERP Developer & Managing


+918233142254 | Skype : opmaurya96

www.maurysolutions.com



_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Thanks & Regards

OM Prakash Maurya

ERP Developer & Managing


+918233142254 | Skype : opmaurya96

www.maurysolutions.com



_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Thanks & Regards

OM Prakash Maurya

ERP Developer & Managing


+918233142254 | Skype : opmaurya96

www.maurysolutions.com



_______________________________________________
Mailing-List: https://www.odoo.com/groups/technical-62
Post to: mailto:technical@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


Reference