Can Process Author Execute SQL?

Is it possible to get Process Author to run some SQL code as one of the events in its Process?

We are using Microsoft SQL and 7.6+

There is a fairly complex calculation we want to do "on save", I appreciate we could conceivably do it in a logic hook or similar but for us it would most easily be done in either a SQL stored proc or UDF.

Regards

Greg

Parents

0 Alan Apter over 9 years ago

Sorry, I know you were specifically asking about Process Author and not a logic hook, but is there any reason you don't want to call the SQL from a logic hook? Sugar has a DBManager class that can call the SQL from within the logic hook after_save, and it'd be easier to implement in my opinion.

Reply

0 Alan Apter over 9 years ago

Sorry, I know you were specifically asking about Process Author and not a logic hook, but is there any reason you don't want to call the SQL from a logic hook? Sugar has a DBManager class that can call the SQL from within the logic hook after_save, and it'd be easier to implement in my opinion.

Children

0 Greg Mackey over 9 years ago in reply to Alan Apter

Oddly, I have done a fair bit with Process Author, but have not done any work in Logic Hooks, hence my preference.
I am happy to give things a try with Logic hooks, can you point me to a good place to start?