c2c-oerpscenario team mailing list archive

["Naresh\(OpenERP\)" <nch@xxxxxxxxxxx>]

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 !

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/802996

Title:
  can't search Sales Order by creation date

Status in OpenERP Server:
  Confirmed

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/802996/+subscriptions