<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML con formato previo Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLconformatoprevioCar
{mso-style-name:"HTML con formato previo Car";
mso-style-priority:99;
mso-style-link:"HTML con formato previo";
font-family:"Consolas","serif";
mso-fareast-language:ES;}
span.hoenzb
{mso-style-name:hoenzb;}
span.EstiloCorreo20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=ES link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>Hi,<br><br>As I can see, this bug is from vt5.2 and not from 5.4. Actually, is supossed that in 5.4 vtiger team fixed this.<br><br>So, I think is the main reason in coreBOS works, just because is an extension from vt5.4.<br><br>I wanted to clarify this for Joe don’t get mad trying to find the fix among coreBOS commits </span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D;mso-fareast-language:EN-US'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'>.<br><br>To OP, try to parse some core files (include/home.php?) with 5.4 files but you must be, very very lucky to make it works. The besy way is debugging and see what is happening and why this $query is doing a bad query.<br><br>Greetings.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>De:</span></b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> vtigercrm-developers-bounces@lists.vtigercrm.com [mailto:vtigercrm-developers-bounces@lists.vtigercrm.com] <b>En nombre de </b>Sreenivas Kanumuru<br><b>Enviado el:</b> martes, 8 de julio de 2014 8:35<br><b>Para:</b> Joe Bordes; vtigercrm-developers@lists.vtigercrm.com<br><b>Asunto:</b> Re: [Vtigercrm-developers] Finding more info regarding fix trac ticket<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><p class=MsoNormal><i><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>This issue is something I have asked many times, vtiger PLEASE document the changes, it is useless to say "it works in the current code", we need to see what you are doing to be able to evaluate and help.</span></i><o:p></o:p></p></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Joe, Since January, we have been adding the change-sets in trac when fixing issues. We weren't following this earlier. I apologize.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Regards,<o:p></o:p></p></div><div><p class=MsoNormal>Sreenivas<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On Fri, Jul 4, 2014 at 3:02 PM, Joe Bordes <<a href="mailto:joe@tsolucio.com" target="_blank">joe@tsolucio.com</a>> wrote:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal>This issue is something I have asked many times, vtiger PLEASE document the changes, it is useless to say "it works in the current code", we need to see what you are doing to be able to evaluate and help.<br><br>@Rami, I had a look to see if I could see it but I have no idea where the change is, all I can say is that it works in coreBOS, so we must have applied the fix along the way. I tried comparing the most obvious places: modules/CustomView, include/utils/ListViewUtils, modules/Home, include/home.php but I couldn't find it.<br><br>All the action happens in include/home.php, on the lines 258-263:<br><br> if($modname == "Calendar"){<br> $listquery = getListQuery($modname);<br> if(trim($listquery) == ''){<br> $listquery = $focus->getListQuery($modname);<br> }<br> $query = $oCustomView->getModifiedCvListQuery($cvid,$listquery,$modname);<br><br><br>in my install and test, the $query variable contains a correct SQL command for my filter.<br><br>Hope that helps...<br><br>Joe<br>TSolucio<o:p></o:p></p><div><div><p class=MsoNormal><br><br><br>On 04/07/14 08:29, Rami Addady wrote:<o:p></o:p></p></div></div></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hello,<br><br>Thank you for your replay<br><br>> Can you please check this issue here in <a href="http://trac.vtiger.com/svn/vtiger/vtigercrm/branches/6.1.0/" target="_blank">vtiger 6.1.0</a> . If its reproducible, please get back to us.<br><br>But V6.1 not relevant to my question.<br><br>It say the ticket was fix in V5.4.<br>How can I find which files where involve?<br><br>Regards,<br>Rami Addady<br><br><o:p></o:p></p><div><p class=MsoNormal>On 07/03/2014 03:44 PM, Uma S wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>Hi, <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Can you please check this issue here in <a href="http://trac.vtiger.com/svn/vtiger/vtigercrm/branches/6.1.0/" target="_blank">vtiger 6.1.0</a> . If its reproducible, please get back to us.<o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Thu, Jul 3, 2014 at 6:05 PM, Rami Addady <<a href="mailto:rami@active.co.il" target="_blank">rami@active.co.il</a>> wrote:<o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hello,<br><br>I'm trying to find the fix to a bug. Bug that was reported as fixed in the trac.<br><br>The ticket mention it was fix in v5.4:<br><a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7074#no2" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7074#no2</a><br><br>How can I locate the file / lines which where involve?<br><br><br>Regards,<br>Rami Addady<br><br><o:p></o:p></p></div><p class=MsoNormal><br>_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><o:p></o:p></p></blockquote></div><p class=MsoNormal><br><br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>-- <o:p></o:p></p><div><p class=MsoNormal>With<br>Best Regards<br>Uma.S<o:p></o:p></p><div><p class=MsoNormal>Vtiger Team<o:p></o:p></p></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><o:p></o:p></pre></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><br><br><o:p></o:p></p></div></div><pre>_______________________________________________<o:p></o:p></pre><pre><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><o:p></o:p></pre></blockquote><p class=MsoNormal><span style='color:#888888'><br><br><br><span class=hoenzb><o:p></o:p></span></span></p><pre><span style='color:#888888'>-- <o:p></o:p></span></pre><pre><span style='color:#888888'>Un saludo<o:p></o:p></span></pre><pre><span style='color:#888888'>Joe<o:p></o:p></span></pre><pre><span style='color:#888888'>TSolucio</span><o:p></o:p></pre></div><p class=MsoNormal><br>_______________________________________________<br><a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><o:p></o:p></p></blockquote></div><p class=MsoNormal><o:p> </o:p></p></div></div></div></body></html>