Hi Karyn,<br><br>Look at file <span style="font-family: courier new,monospace;">include/utils/ListViewUtils.php</span><br><br><span style="font-family: courier new,monospace;">function getListQuery</span><br><br>Regards,<br>
Prasad<br>vtiger Team<br><br><div><span class="gmail_quote">On 6/12/08, <b class="gmail_sendername">Karyn Cassio</b> <<a href="mailto:KarynC@transmagic.com">KarynC@transmagic.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hi,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I'm trying to customize the initial Contacts ListView
for a custom filter.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I have been able to add other related fields to search on
from the Accounts table, </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">but now I need to search some of the accounts subtables,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">for instance vtiger_accountscf fields.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I know, to make this happen I need to edit the initial
SELECT statement and add some additional joins.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">My problem is I can't seem to find where the SELECT
statement is initiating from.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I'm doing a CallStack on the query, but I'm
still having a hard time finding it.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Any thoughts or suggestions would be greatly appreciated. </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I will continue on my search, but if someone could point me
in the right direction it should help speed things up.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">;-)</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks in advance,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><b><font color="gray" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: gray; font-weight: bold;">Karyn </span></font></b></p>
<p><b><font color="gray" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: gray; font-weight: bold;">Web
Developer</span></font></b></p>
<p><b><font color="gray" face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; color: gray; font-weight: bold;">TransMagic,
Inc.</span></font></b><font color="navy" face="Tahoma"><span style="font-family: Tahoma; color: navy;"> <br>
<br>
</span></font><font color="navy"><span style="color: navy;"></span></font></p>
</div>
</div>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>