Skip to main content
Known Participant
Jul 12, 2023 12:47 PM UTC
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!

    mikes0011
    mikes0011Answer
    Brainy
    Jul 12, 2023 1:00 PM UTC

    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

    2 replies

    mikes0011
    mikes0011Answer
    Brainy
    Jul 12, 2023 1:00 PM UTC

    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
    Known Participant
    Jul 13, 2023 1:23 PM UTC

    Thanks Mike!