<div dir="ltr">Hi,<br><br>I recommend if you want to sort your related list by the default_order_by and default_sort_order, modify:<br><br>modules/Vtiger/models/RelationListView.php<br><br>after<br><br><div>$orderBy = $this->getForSql('orderby');</div><div>$sortOrder = $this->getForSql('sortorder');<br><br>add<br><br><div>if(empty($orderBy) && empty($sortOrder) && $relationModuleName != "Users"){</div><div>                        if(PerformancePrefs::getBoolean('LISTVIEW_DEFAULT_SORTING', true)) {</div><div>                                $moduleFocus = CRMEntity::getInstance($relationModuleName);</div><div>                </div><div>                                $orderBy = $moduleFocus->default_order_by;</div><div>                                $sortOrder = $moduleFocus->default_sort_order;</div><div>                        }</div><div>                }</div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2014-09-17 22:01 GMT+02:00 Jonathan Sardo <span dir="ltr"><<a href="mailto:sardoj@gmail.com" target="_blank">sardoj@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi !<div><br></div><div>This is a way to correctly sort a ListView according with the field <i>$default_order_by  </i>defined in the module class:</div><div><br></div><div>Edit "/modules/Vtiger/models/ListView.php" and add the following code at the line 188, after $sortOrder = $this->getForSql('sortorder') :</div><div><br></div><div>







<p><i><span>if</span><span>(</span><span>empty</span><span>(</span>$orderBy<span>) && </span><span>empty</span><span>(</span>$sortOrder<span>) && </span>$moduleName <span>!= </span><span>"</span><span>Users</span><span>"</span><span>)<br></span>{<br><span>   if</span><span>(!</span><span>empty</span><span>(</span>$moduleFocus<span>-></span>default_order_by<span>))<br></span>   {<br>      $orderBy <span>= </span>$moduleFocus<span>-></span>default_order_by<span>;<br></span>   }</i></p>
<p><i><span>  </span><span>       </span><span>       </span></i></p>
<p><i><span><span></span><span></span><span></span></span><span>   if</span><span>(!</span><span>empty</span><span>(</span>$moduleFocus<span>-></span>default_sort_order<span>))<br></span>   {<br>      $sortOrder <span>= </span>$moduleFocus<span>-></span>default_sort_order<span>;<br></span>   }<br>}</i></p><div><div dir="ltr"><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.7272720336914px;background-color:rgb(255,255,255)"><div><br></div><div>Regards,</div><div><br></div><div><div><font color="#666666">Jonathan SARDO</font></div><div></div><div style="color:rgb(136,136,136)"><img src="cid:ii_13df029e6cb01b67" alt="Images intégrées 5"><br></div><div style="color:rgb(136,136,136)"><span style="color:rgb(0,0,0);font-family:arial;font-size:small">Tél. <a value="+33699455047" style="color:rgb(17,85,204)">06 99 45 50 47</a></span></div></div></div></div></div>
</div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>