Hey guys. All good ?
I need your help with a query I created. The code below has only returned one line, however I need it to return the same number of lines as the "Quantity_Tags" column for my Add-on to understand the number of labels it should print. Could someone help me how to change this query or create a view for it?
SELECT
T0."ItemCode",
T1."ItemName",
T1."U_Planeta_MultiplosEtiquetas" as "Quantity",
T0."DocNum",-- Code 128
T0."PostDate" as "DocDate",
T1."CodeBars" as "CodeBars" -- Ean 13
(T0."PlannedQty"/T1."U_Planeta_MultiplosEtiquetas") as "Quantity_Tags"
FROM
OWOR T0
INNER JOIN
OITM T1
ON T0."ItemCode" = T1."ItemCode"
WHERE
T0."ObjType" = [%ObjType%]
and T0."DocEntry" = [%DocEntry%]
and [%LineNum%] = '-1'