tag:blogger.com,1999:blog-518307109112772972.post1997347384395909728..comments2024-03-28T00:29:34.101-04:00Comments on Gonzalo Ruiz - Dynamics CRM: All about outer join queries in CRM 2011 and CRM 2013Gonzhttp://www.blogger.com/profile/02521457712101956774noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-518307109112772972.post-29034740589841852972016-01-07T16:32:36.588-05:002016-01-07T16:32:36.588-05:00Thanks there was a typo which is now corrected. I ...Thanks there was a typo which is now corrected. I was missing defining the alias "ab"Gonzhttps://www.blogger.com/profile/02521457712101956774noreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-36856799487266799442015-11-29T23:07:42.745-05:002015-11-29T23:07:42.745-05:00Number 3 is not correct, fetchxml is closed incorr...Number 3 is not correct, fetchxml is closed incorrectly, there is no entity called ab in the entire fetchxml. It seems that author has not tested his own code.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-76094401481764398832015-08-08T10:21:19.270-04:002015-08-08T10:21:19.270-04:00http://blog.cobalt.net/blog/building-not-in-querie...http://blog.cobalt.net/blog/building-not-in-queries-using-dynamics-crm-advanced-find<br /><br />We made a solution for 2013 and 2015 that does outer joins depending on how you setup your query in advanced find. This allows the user to easily do "not in" queries. Nathanhttp://www.cobalt.netnoreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-22844575824151326872014-08-19T16:12:24.726-04:002014-08-19T16:12:24.726-04:00Same question as Joe above.. How does one go abou...Same question as Joe above.. How does one go about adding one of these tweaked system views to a dashboard. For some reason said left outer join view is missing from the view selector when adding a dashboard component....Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-69625583857511074452014-06-25T14:59:29.707-04:002014-06-25T14:59:29.707-04:00Step "2. CRM 2011: Use the SDK" isn'...Step "2. CRM 2011: Use the SDK" isn't entirely correct (Or maybe put in a better way, your work around isn't the best possible), You can perform a single query with a left outer join, and return back the id of the outer joined table as an aliased attribute. Then use LINQ to objects on the client side to only actually return Entities that don't have the joined table. Using the entities in your example, you'd still be returning all of the leads (So you'd have to consider paging if there are more than 5000), but you wouldn't be returning all of the Tasks, and there is no merge on the client side.Darylhttps://www.blogger.com/profile/11229612024940240358noreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-77319159625097820022014-04-23T11:46:38.562-04:002014-04-23T11:46:38.562-04:00Gonzalo, if we want to return only Leads that do n...Gonzalo, if we want to return only Leads that do not have active tasks but may or may not have inactive tasks, would we nest the filter in the or in the ?Anonymoushttps://www.blogger.com/profile/18252569105666421683noreply@blogger.comtag:blogger.com,1999:blog-518307109112772972.post-84281419646969718232014-04-22T11:41:32.829-04:002014-04-22T11:41:32.829-04:00Hi Gonzalo,
Strange behavior when trying to add a...Hi Gonzalo,<br /><br />Strange behavior when trying to add a customized System View (method discussed in #3) to a dashboard. The view shows up in the normal view but does not show up in the list of views to be selected.<br /><br />Is there an XML node/attribute that is required in order to be able to add a System View to a Dashboard?<br /><br />Thanks in advance,<br /><br />JoeJoe Newstromnoreply@blogger.com