Hi Eveyone,
I want to filter the products in the "All products and product masters" tab under "Product Information Management" that do not have any Product Categories set.
i wrote the following job but it wont work , i need further help
static void Job72(Args _args)
{
InventTable inventTable;
EcoResProductCategory ecoResProductCategory;
while select * from inventTable
not exists join ecoResProductCategory where
inventTable.product==ecoResProductCategory.product
if(ecoResProductCategory!=null)
{
info(strFmt("%1" ,inventTable.ItemId ));
}
}
*This post is locked for comments
I have the same question (0)
