how can show itemname in Query manager?

[former_member373665]

If I do a query using items, when i choose de range of items only show ItemCode and numbers of records, how can also show itemname??

[Former Member]

Hi,

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0

WHERE T0.[ItemCode] between 'A00001' AND 'A00007'

[Former Member]

hi,

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0 
WHERE T0.[ItemCode] >= '20004000' AND  T0.[ItemCode] <= '20005000'

regards,

varma

[Former Member]

Dear Mariano Fernandez Bustillos,

You could show the ItemName like following query:

SELECT T0.[ItemCode], T0.[ItemName] 
FROM OITM T0 
WHERE T0.[ItemCode] > 'A00001' 

Best Regards

Jane Jing

SAP Business One Forums team