• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 95 subscribers
  • Views 4060 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Where to write add/edit/insert statements?

IDM Engineer
over 8 years ago

I created a custom target, which is an external database. Further, I configured some entitlements which are requestable from the IT Shop. A user will request these entitlements, it will go thru an approval and finally get approved. Upon approval I want to write 'INSERT' sql statement to assign appropriate entitlement to the user (in the target system), where should I write this code? Similarly I want to write DELETE stmt to remove entitlement. I'm new to this tool, please be more specific in your details. Thanks. 

Parents
  • 0 over 8 years ago
    Thanks George

    So I inserted some command, following the convention:
    <custom prefix>_<table>_<ident_UNSRoot>_<event>

    But how the code will trigger these functions? For example, I added service items to the ITShop, created a workflow and upon approval, I'm seeing record getting added to the PersonWantOrg table but it should also trigger code in the UNSAccountBInUNSGroupB_INSERT but nothing is happening. Can you please guide me. Thanks
Reply
  • 0 over 8 years ago
    Thanks George

    So I inserted some command, following the convention:
    <custom prefix>_<table>_<ident_UNSRoot>_<event>

    But how the code will trigger these functions? For example, I added service items to the ITShop, created a workflow and upon approval, I'm seeing record getting added to the PersonWantOrg table but it should also trigger code in the UNSAccountBInUNSGroupB_INSERT but nothing is happening. Can you please guide me. Thanks
Children
No Data