Bug 1597 - Report Lagerbestand wirft Fehler, wenn Artikelnummer ausgeblendet werden soll
SELECT b.id AS binid, p.description AS partdescription, b.description AS bindescription, i.warehouse_id AS warehouseid, i.chargenumber AS chargenumber, w.description AS warehousedescription, i.parts_id AS parts_id, SUM AS qty, p.unit AS partunit FROM inventory i LEFT JOIN parts p ON i.parts_id = p.id LEFT JOIN bin b ON i.bin_id = b.id LEFT JOIN warehouse w ON i.warehouse_id = w.id
WHERE 1=1 GROUP BY binid, partdescription, bindescription, warehouseid, chargenumber, warehousedescription, parts_id, partunit ORDER BY partnumber ASC FEHLER: Spalte »p.partnumber« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden
Bug 1597 - Report Lagerbestand wirft Fehler, wenn Artikelnummer ausgeblendet werden soll
SELECT b.id AS binid, p.description AS partdescription, b.description AS
bindescription, i.warehouse_id AS warehouseid, i.chargenumber AS chargenumber,
w.description AS warehousedescription, i.parts_id AS parts_id, SUM AS
qty, p.unit AS partunit
FROM inventory i
LEFT JOIN parts p ON i.parts_id = p.id
LEFT JOIN bin b ON i.bin_id = b.id
LEFT JOIN warehouse w ON i.warehouse_id = w.id
WHERE 1=1
GROUP BY binid, partdescription, bindescription, warehouseid, chargenumber,
warehousedescription, parts_id, partunit
ORDER BY partnumber ASC
FEHLER: Spalte »p.partnumber« muss in der GROUP-BY-Klausel erscheinen oder in
einer Aggregatfunktion verwendet werden