Available Plugin Messages for a Given Entity in CRM 4.0

azimmer — Mon, 15 Feb 2010 13:00:00 GMT

When I get an unusual plugin request from one of our business analysts, the first thing I ask myself is, "Do they have a message I can hijack?"

With the plugin registration tool, you specify your message first and then the second field filters by what entities support the message. That isn't very useful when you want to determine what messages are available for a given entity.

I found this useful query on eggheadcafe, posted by Ajith of Microsoft. http://www.eggheadcafe.com/software/aspnet/31684630/plugin-for-closeopen-opp.aspx

Just specify the entity name run the query... Hook up the event and start debugging... Hopefully the message is what you are looking for!

select m.name as 'Name Of Method',
CASE m.availability
WHEN '0' THEN 'Server'
WHEN '1' THEN 'Offline'
WHEN '2' THEN 'Both'
END
as 'MessageAvailability',
CASE mf.availability
WHEN '0' THEN 'Server'
WHEN '1' THEN 'Offline'
WHEN '2' THEN 'Both'
END
as 'SupportedDeploymentForEntity',
e.name as 'PrimaryEntityName',s.name as 'SecondaryEntityName'
from sdkmessagefilter mf inner join sdkmessage m on m.sdkmessageid =
mf.sdkmessageid
left outer join entity e on e.objecttypecode = mf.primaryobjecttypecode
left outer join entity s on s.objecttypecode = mf.secondaryobjecttypecode
where mf.primaryobjecttypecode < 10000
and mf.primaryobjecttypecode >= 0 -- Includes Enity.none
and mf.iscustomProcessingstepallowed = 1
and e.name ='lead'
order by m.name, e.name

Enjoy!

-Andrew

Search results matching tag 'messages'

Available Plugin Messages for a Given Entity in CRM 4.0