Revision b877d633
Von G. Richardson vor mehr als 4 Jahren hinzugefügt
SL/DB/Part.pm | ||
---|---|---|
373 | 373 |
LEFT JOIN warehouse w ON (i.warehouse_id = w.id) |
374 | 374 |
LEFT JOIN bin b ON (i.bin_id = b.id) |
375 | 375 |
WHERE parts_id = ? |
376 |
GROUP BY w.description, b.description, p.unit, i.parts_id |
|
376 |
GROUP BY w.description, w.sortkey, b.description, p.unit, i.parts_id
|
|
377 | 377 |
HAVING SUM(qty) != 0 |
378 | 378 |
WINDOW pt AS (PARTITION BY i.parts_id ORDER BY w.sortkey, b.description, p.unit), |
379 | 379 |
wh AS (PARTITION by w.description ORDER BY w.sortkey, b.description, p.unit) |
Auch abrufbar als: Unified diff
Neuer index auf inventory über itime und parts_id
Um Abfragen wiezu beschleunigen