Activity log for bug #557326

Date Who What changed Old value New value Message
2010-04-07 14:11:10 Numérigraphe bug added bug
2010-04-13 11:39:39 Numérigraphe nominated for series openobject-server/trunk
2010-07-10 11:41:15 Jay Vora (Serpent Consulting Services) openobject-server: importance Undecided Wishlist
2010-07-12 07:33:54 Numérigraphe description Answers for Question #106692 indicate that for the moment we can't do a "SELECT DISTINCT" using the ORM. There are cases where this would be useful (like searching the order ids in order lines), so I propose we add a new parameter "distinct=False" to the search() method of th OSVs. When set to True, it would return distinct tuples only. It seems easy to add in osv using a SELECT DISTINCT statement. It may be a bit more tricky in osv_memory, and it will run slower of course, and none sane will use it there I suppose, so we should just throw a "not implemented" exception I guess. Lionel Answers for Question #106692 indicate that for the moment we can't do a "SELECT DISTINCT" using the ORM. There are cases where this would be useful (like searching the order ids in order lines), so I propose we add a new parameter "distinct=False" to the read() method of th OSVs. When set to True, it would return distinct tuples only. It seems easy to add in osv using a SELECT DISTINCT statement. It may be a bit more tricky in osv_memory, and it will run slower of course, and none sane will use it there I suppose, so we should just throw a "not implemented" exception I guess. Lionel
2010-07-12 07:34:15 Numérigraphe description Answers for Question #106692 indicate that for the moment we can't do a "SELECT DISTINCT" using the ORM. There are cases where this would be useful (like searching the order ids in order lines), so I propose we add a new parameter "distinct=False" to the read() method of th OSVs. When set to True, it would return distinct tuples only. It seems easy to add in osv using a SELECT DISTINCT statement. It may be a bit more tricky in osv_memory, and it will run slower of course, and none sane will use it there I suppose, so we should just throw a "not implemented" exception I guess. Lionel Answers for Question #106692 indicate that for the moment we can't do a "SELECT DISTINCT" using the ORM : see https://answers.launchpad.net/openobject-addons/+question/106692 There are cases where this would be useful (like searching the order ids in order lines), so I propose we add a new parameter "distinct=False" to the read() method of th OSVs. When set to True, it would return distinct tuples only. It seems easy to add in osv using a SELECT DISTINCT statement. It may be a bit more tricky in osv_memory, and it will run slower of course, and none sane will use it there I suppose, so we should just throw a "not implemented" exception I guess. Lionel
2010-11-23 23:51:03 Olivier Dony (Odoo) openobject-server: status New Confirmed
2010-11-23 23:51:03 Olivier Dony (Odoo) openobject-server: assignee OpenERP's Framework R&D (openerp-dev-framework)
2014-04-14 13:08:31 Lionel Sausin - Initiatives/Numérigraphe bug added subscriber Lionel Sausin - Numérigraphe
2014-04-14 13:08:38 Numérigraphe removed subscriber Numérigraphe
2014-04-14 13:38:28 Mohamed Fadhel Hadj Salem bug added subscriber Mohamed Fadhel Hadj Salem