http://forums.method.me/cs/forums/30.aspxAsk technical support questions, how do I?...or anything else you want to know from the Method Team.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/36312.aspxTue, 15 Sep 2020 14:13:20 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:36312Method_Inderdeep0http://forums.method.me/cs/forums/thread/36312.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=30&PostID=36312<p><span id="mce_0_start" style="overflow:hidden;">Hi Leigh,</span></p> <p></p> <p>We currently do not have SQL overrides in the new version of Method.<span id="mce_1_start" style="overflow:hidden;"> Since there is no 1:1 relationship with there could be many Estimates related to an opportunity. Once this realtionship is created with the help of customization you can use the custom filters to achieve the above request.</span>&nbsp;<span id="mce_2_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;">It is a little complex customization but definitely achievable. If you wish to know more about this or need guidance, our consulting team (billable service) can definitely help you with this.&nbsp;<span id="mce_4_start" style="overflow:hidden;"></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><br /></span></span></p> <p>Cheers,</p> <p>Inder</p>http://forums.method.me/cs/forums/thread/36299.aspxTue, 21 Jul 2020 17:03:21 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:36299LeighP@Eagle0http://forums.method.me/cs/forums/thread/36299.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=30&PostID=36299<p><span id="mce_0_start" style="overflow:hidden;">Hi there,&nbsp;</span></p> <p>Is there a way to get a grid view of all the opportunities that don&#39;t have an estimate linked to them?</p> <p>Ordinarily, I would write a &quot;not in&quot; SQL<span id="mce_2_start" style="overflow:hidden;"></span> to achieve this but I can only find information about SQL overrides in older versions of Method in the forum.&nbsp;&nbsp;</p> <p><span id="mce_1_start" style="overflow:hidden;"></span>Thanks!</p> <p>Leigh</p>