Wednesday, March 16, 2016

Get All Plugin Registation Steps (SQL) MSCRM

Hi All,

Please find the below SQL script to get all the plugin registration steps

SELECT T.PluginAssemblyIdName AS PluginName, S.name AS StepName,
S.description AS StepDescription, M.name AS Action, E.name AS Entity,
CASE S.Stage WHEN 20 THEN 'PRE' WHEN 40 THEN 'POST' ELSE 'OTHER' END AS Stage,
CASE S.StateCode WHEN 0 THEN 'Enabled' WHEN 1 THEN 'Disabled' ELSE 'Other' END AS State
FROM SdkMessageProcessingStepBase S -- Steps Table
JOIN SdkMessage M ON(S.SdkMessageId = M.SdkMessageId)
JOIN SdkMessageFilter F ON(S.SdkMessageFilterId = F.SdkMessageFilterId)
JOIN EntityAsIfPublishedLogicalView E ON(E.ObjectTypeCode = F.PrimaryObjectTypeCode)
JOIN PluginType T ON(T.PluginTypeId = S.PluginTypeId)



No comments:

Post a Comment

Day 23: Creating New Records Programmatically with JavaScript in Dataverse / MSCRM

In this Blog, we will see how to Create New Records Programmatically with JavaScript in Dataverse / MSCRM var record = {}; record.bosch_day...