Stored Proc Call

Hi Everyone,

Is there a way to find out where the stored procedure created in database is being called in which process model through execute proc smart service?

Thank you!

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer

    If you're keeping the Stored Procedure's name in a (text) Constant, you would simply be able to search dependents for that constant to see where it's called.  If for some reason the SP name is being hardcoded in different places, then searching for it will be a bit more difficult, though you can always try using the "expression" search in the global objects viewer. 

    Additionally if you're using the (older) Stored Procedure plug-in version of the smart service (versus the newer OOB version), you can look at dependents for the plug-in itself.  If you're using a!executeStoredProcedureForQuery(), you could at least do an expression search for places that call that.

Reply
  • +1
    Certified Lead Developer

    If you're keeping the Stored Procedure's name in a (text) Constant, you would simply be able to search dependents for that constant to see where it's called.  If for some reason the SP name is being hardcoded in different places, then searching for it will be a bit more difficult, though you can always try using the "expression" search in the global objects viewer. 

    Additionally if you're using the (older) Stored Procedure plug-in version of the smart service (versus the newer OOB version), you can look at dependents for the plug-in itself.  If you're using a!executeStoredProcedureForQuery(), you could at least do an expression search for places that call that.

Children