c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Wednesday 22 December 2010, you wrote:
> Public bug reported:
> 
> to reproduce
> clear
> extra filter location=output (looks OK without investigating the data)
> group by category


I did a quick analysis of the current implementation[1] and verified my initial 
hunch:
 - function/related fields are *not* computed by the orm.read_group(), meaning 
that sums like the "qty_available" of "product.product" will not appear in 
grouped lists.

In a related note, the fact that "0.0" appears rather than <Null> empty 
columns[2] at the GUI may be wrong. It's due to our other "null means zero" 
mis-feature of the framework.

I realize that the current behaviour is far from the expected, as you have 
correctly requested. Still, I'm reluctant to start patching the framework of 
v6.0, at this stage, for that.
One reason is that I hope we can get much better SQL-oriented handling of 
complex queries after v6.0. That, would be the best solution, more efficient 
than a pythonic "dirty sum" that we would write for the current ORM.

I'm waiting for the other experts' opinion on the roadmap of this bug. Shall 
we defer for v6.1/v6.2 ?


[1] some parts of the code are not my expertise, but I like to read them.
[2] even after writting an agregation framework for these columns, we shall 
expect some modules to have non-aggregate compliant columns. For those, we 
need to return an empty/not-available/unknown indication.

-- 
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/693460

Title:
  [6.0 RC1] products  filter location and group  by  category give wrong results

Status in OpenObject Server:
  Confirmed

Bug description:
  to reproduce
clear 
extra filter location=output (looks OK without investigating the data)
group by category
some issues
- every row shows 0 values
** negativ value of virtual stock missing [PC1]
opening any of the categories - shows all products + quantities (presumably of all stock locations)

IMHO it's a real drawback not beeing able to filter "Real Stock" 
Example 
* "Real Stock" is not 0 
to show only available products