Solved
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!
mikes0011Answer
Brainy
July 12, 2023
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.
The Expression Guru