Tryton - Issues

 

Issue7471

Title Allow to use Exclude with range
Priority feature Status unread
Superseder Nosy List ced, vbastos
Type performance Components trytond
Assigned To Keywords
Reviews

Created on 2018-05-28.13:30:40 by ced, last changed by vbastos.

Messages
msg41068 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2018-05-28.13:30:39
For example, the fiscal year overlaps check could be rewritten using an Exclude constraint with the range type [1].
The problem is that sqlite does not have the range type (nor the overlap operator). Indeed range type is specific to PostgreSQL.
But the overlap constraint is a common need for resource planning so I think we should have tools for that.
I think it must be possible to create an python-sql Operator to use in Exclude that will be converted into a composed where clause for backend that does not support range.

[1] https://stackoverflow.com/a/46580467/3541219
History
Date User Action Args
2018-07-09 01:32:01vbastossetnosy: + vbastos
2018-05-28 13:30:40cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)