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

Deferred Request (WC) Function Call

I'm looking at implementing an Approval Workflow that will go through some actual approval steps but for the final step I want to check that a few things are set to specific values in the database. Looking at the documentation for the Deferred Request Approval Procedure, I think I should be able to do this. My question is around the function that it uses. The example gives dbo.<function name>. So I suppose this is going to be SQL? I would prefer to do it in VB if that's possible. Where do I define this function? Do I need to go into sql and define the function there or is there somewhere within One Identity that I can define a SQL function that I can refer to for this Approval Procedure?

  • I got this working no problem, but I don't like how the scala sql function exists outside of the solution and isn't attached to any change label. It's just sitting in the database and this won't migrate between environments as far as I know.
  • As I understand the approval step EX can be used to raise a custom event which in turn will invoke a process where you can run your VB script.

    The Sql function you made can be transported I think, I recall seeing somewhere in the transporter you can specify some Sql to run as part of the transport so in theory you could create the sql function in there.

    HTH
    Kin