Skip to content

rajyraman/AdvancedQueryOuterJoin

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CRM2015 doesn't allow outer join queries through the UI. This plugin enabled you to do that. The plugin runs on pre-RetrieveMultiple and alter the query that gets sent to the pipeline, with the correct outer join conditions.

Basically the plugin enables you to do advanced find queries like this AdvancedFind

Without the plugin running in the background, you would normally get no records, for a query like the one above. The query above retrieves account that have child contacts, but don't have any opportunities.

This is how the plugin is registered PluginRegistration

The execution of this plugin is not restricted to just the Advanced Find. Basically, as you can see from the screenshot above, it runs for all RetrieveMultiple requests. If this is going to be performance issue for your CRM instance, you can update the RetrieveMultiple step with an entity, that requires this functionality. The code has to be modified slightly as well.

About

Plugin to enable outer join queries from Advanced Find

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages