Skip to main content

Hello everyone,

I have a nested cutom entity under ProductStructureComponent : 

 

I want that when I delete a Product Structure Component line, the nested entity lines linked are also removed. Do you know a way to do that ?

 

I tried using a workflow but wouldn’t manage to trigger the workflow on ProductStructureComponentArray line removal. If using a workflow is the only way to delete associated records, can you let me know what projection or event can I use to trigger it please ?

 

Thank you

Hello Juliette,

You must be able to use the remove procedure from your entity API (plsql package) with an event action triggered on the deletion of the main row.
This procedure require an objkey as parameter which you can fetch first in your event action

here is signature : 

PROCEDURE Remove__ (
info_ OUT VARCHAR2,
objkey_ IN VARCHAR2,
objversion_ IN VARCHAR2,
action_ IN VARCHAR2 )
IS

If your solution is full Cloud and not On Premise, it might be harder to debug as you don’t have access to database.
Keep in consideration I’m new on IFS ecosystem and actually working on migration from V8 to cloud, there might be better solution , closer to IFS standards


Reply