Is it possible to delete records from WORK_SCHED_ASSIGN using Data Migration and WORK_SCHED_ASSIGN_API.Remove__
Can anyone please advise how this is done.
+9I would imagine it is.
You add that in the method instead of just the api and view. And leave the new and modify ticks blank.
i dont know which input it needs that paricular function though.
+3If I know more about your requirment, probably can come up with different solution.
From where do you get the list of records need to be deleted? From IFS or from a thirdparty system? Howmany records and how frequent?
+7Crazy thought….
- Make a copy of WORK_SCHED_ASSIGN_API. For example, MY_WORK_SCHED_ASSIGN_API
- Edit the New__ procedure in the package to perform the Remove__ operations.
When you register the API and check the “New” box it would then call your removal code. It will take more editing, but can be done.
johnw66 wrote:
Is it possible to delete records from WORK_SCHED_ASSIGN using Data Migration and WORK_SCHED_ASSIGN_API.Remove__
Can anyone please advise how this is done.
It is possible to do that. You need to pass Objid, Objversion with the ‘DO’ as the action. specify the correct parameter to select the records you need to remove.
(I have sued in other APIs but on the exact API you have mentioned)
Hey,
If you cant use standard procedure in migration job, consider using migration job+ custom view+event, below post might help
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.