Workflow alert recipients

Question

Hello,

I'm working with Sugar Professional 9.0.0.

In Admin -> Workflow management each workflow has recipients. I'm trying to find the list of recipients for each workflow definition in the database.

I can't seem to find any indication of where this might be.

Any help would be greatly appreciated.

Chris Bourgeois · Accepted Answer

I opted to contact Sugar support and while there is a way to build a query to pull this information getting it manually was quicker. Here's the response form support though. I looked at this in a stock instance. I found that this information can be tricky to have pulled together in one easy to read format due to the way the data is stored. Everything can be found in the Workflow_alerts table in the database in the field_value column. however all the data that may be there could be things like user id's and possibly assigned user information. It may be necessary to join these tables in a query with a few other tables based on the ID field of those tables to possibly generate some results that are comprehensible. Below I included a screenshot of a database diagram that focuses on this particular module.