Odoo Addons (MOVED TO GITHUB)

can't search Sales Order by creation date

Bug #802996 reported by Mihai Satmarean
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Low
OpenERP R&D Addons Team 3
Odoo Addons (MOVED TO GITHUB) 6.1

Bug Description

I want to see all Sales orders created today
I go in Custom filters and add
"Creation date" is equal to 2001-06-28
and it gives me all sales

if I change the filter to "order date" and leave the same date, it will return only good results

I can go in Form->Log and check creation date and last modified date. I would like to use the filters based on this value.

Thanks

Related branches

lp:~openerp-dev/openobject-addons/trunk-bug-802996-bde
Mustufa Rangwala (Open ERP) (community): Approve
qdp (OpenERP): Pending requested
Diff: 25 lines (+2/-2)
2 files modified
sale/sale.py (+1/-1)
sale/sale_view.xml (+1/-1)
Revision history for this message
Amit Parik (amit-parik) wrote :

Hello,

I have checked this issue at my end.
The "create_date" field can't searchable in all views example: SO, crm.lead.
I am also checked with the GTK and web-client both But both are gives same result it means "Nothing to be displayed"

So this is the general issue of create_date field.

So currently I am assign this to server side.

Thanks.

affects: openobject-addons → openobject-server
Changed in openobject-server:
assignee: nobody → OpenERP's Framework R&D (openerp-dev-framework)
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
Naresh(OpenERP) (nch-openerp) wrote :

Hello,

for problem of Sale Order: The _columns of SO has redefined the field create_date with new type as "date" where as OpenERP has predefined fields:id, create_date, write_date, create_uid, write_uid which means that there is no need for the developer to redefine those fields in his/her model.... but if he does so then ORM will ignore this fields while creating the instance. So the new type here in SO will not be changed at DB level where as it will show its effect only at view level. So when a user searches with this field then he is actually doing a search on a datetime field which has time also stored in db and resulting in no results.

The solution is to change the type to "Datetime" in SO.

For general search on create_date/write_date:
The bug report for this part seems invalid as the value of this field in DB will be stored along with the timestamp. So for such fields the user needs to make a search using the between(< & >) operator instead of "=" operator.

@ community Team: can you please change the project and team to related addons project and team.

correct me if I am missing something !

Thanks !

Revision history for this message
Vinay Rana (OpenERP) (vra-openerp) wrote :

@Addons3: Here we need to use the same datatype for create_date field. Naresh already explained in last commment.

Thanks.

affects: openobject-server → openobject-addons
Changed in openobject-addons:
assignee: OpenERP's Framework R&D (openerp-dev-framework) → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
Revision history for this message
Bharat Devnani (Open ERP) (bde-openerp) wrote :

Hello Mihai Boiciuc,

Following are the Revision ID and Number of the bug :

Revision ID : bde@tiny2-desktop-20110707092531-sofhju5re6d083af
Revision Number : 4858

Thanks for reporting. this will be merged in addons soon.

Regards,
Devnani Bharat R.

Bharat Devnani (Open ERP) (bde-openerp)
Changed in openobject-addons:
status: Confirmed → Fix Committed
Mustufa Rangwala (Open ERP) (mra-tinyerp)
Changed in openobject-addons:
milestone: none → 6.1
Fabien (Open ERP) (fp-tinyerp)
Changed in openobject-addons:
status: Fix Committed → Fix Released
Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :

The fix has landed in trunk at revision 5044 revid:<email address hidden>
Thanks for helping to improve OpenERP!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.