Skip to Content
0
Aug 31, 2023 at 01:28 PM

Query for print tags

27 Views

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'