Job class to update" item model group "in inventModelGroupItem Table i'm facing issues !

(1) Share

Report

Posted on by JJDunaid

206

Hi every one!I have a requirement to change itemmodelgroup of item from /inventModelGroupItem/ table. Ihave to select UPDATE model group only where item type is /Item/ for all items. Item type is coming from Invent Table so Ihave to join the tables and then select /inventModelGroupItem/ for update.when i run thi class i face the error /Cannot edit a record in Relationship between items and item model groups (InventModelGroupItem). The record has never been selected/. I have added the following code :

 InventModelGroupItem  inventModelGroupItem;        EcoResProduct         ecoresproduct;        InventTable           inventTable;        ttsBegin;                 while select forUpdate inventModelGroupItem            where inventModelGroupItem.ItemId != ''            join inventTable            where inventModelGroupItem.ItemId         == inventTable.ItemId            &&    inventModelGroupItem.ItemDataAreaId == 'QTS'            &&    inventTable.ItemType   == ItemType::Item        inventModelGroupItem.ModelGroupId = 'WA';        inventModelGroupItem.update();            ttsCommit;        info(/completed/);

All responses (1)

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 9,818 Super User 2024 Season 2 on at

Like (0)

Report
Job class to update" item model group "in inventModelGroupItem Table i'm facing issues !

Hi,

make sure you pointed to the legal entity QAS

otherwise you can use changeCompany('USMF')

try this :

while select forUpdate inventModelGroupItem where inventModelGroupItem.ItemId != '' join inventTable where inventModelGroupItem.ItemId == inventTable.ItemId && inventModelGroupItem.ItemDataAreaId == inventTable.DataAreaId && inventTable.ItemType == ItemType::Item { }

Best regards,

Mohamed Amine MAHMOUDI