Skip to main content
Question

ProductStructureComponents nested entity records delete

  • November 12, 2024
  • 1 reply
  • 32 views

Forum|alt.badge.img+1

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

1 reply

REOGIRARD
Do Gooder (Customer)
Forum|alt.badge.img+6
  • Do Gooder (Customer)
  • 12 replies
  • January 6, 2025

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings