CRM2013: Get Business Process Flow and Stage GUID’s in SQL

Currently have a requirement from a client where they require a lead to be defaulted with the correct business process flow and stage based on where the lead was generated (through their web portal)

The information is stored in the FilteredProcessStage view in the organisations database.

The query below will output the process and its stages unique references for a particular business process flow.

It is possible to access this information with JavaScript however this was a more efficient way due to the amount of processes the client has.

select processidname,processid,stagename,processstageid from FilteredProcessStage where processidname = 'XXXXXX'

This was passed on to the web portal developers to inject into the lead on creation through the SDK





Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.