<div dir="ltr">It looks like you've made a small change; attached as a patch. Testing now.</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Apr 12, 2013 at 10:39 AM, Joe Bordes <span dir="ltr"><<a href="mailto:joe@tsolucio.com" target="_blank">joe@tsolucio.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hi Adam,<br>
<br>
I just tried it (again) in our online Timecontrol/Payment demo
install:<br>
<br>
<a href="http://crmevolutivo.com/vt_timecontrol54/index.php?action=index&parenttab=Inventory&module=CobroPago&viewname=69" target="_blank">http://crmevolutivo.com/vt_timecontrol54/index.php?action=index&parenttab=Inventory&module=CobroPago&viewname=69</a><br>
<br>
I created a list view for payments showing assigned to and uitype
101 and it seems to work<br>
<br>
I really can't be sure if we are running a clean QG without
comparing. I attach the file that is present in the version we
install by default on our clients in case you want to compare.<br>
<br>
Joe<br>
TSolucio<br>
<br>
<br>
El 12/04/13 16:24, Adam Heinz escribió:<br>
</div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">I've finally circled back around on this one now
that we're on 5.4, but I'm still seeing the same error, "Not
unique table/alias: 'vtiger_users'." I'm staring at some
relevant code [1] in QueryGenerator and it seems pretty clear
that it's not aliasing table names, so the collision is
inevitable. Have you modified QueryGenerator at all?
<div class="gmail_extra">
<br>
</div>
<div class="gmail_extra">[1] <a href="http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/QueryGenerator/QueryGenerator.php#L327" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/QueryGenerator/QueryGenerator.php#L327</a></div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Oct 10, 2012 at 1:47 PM, Joe
Bordes <span dir="ltr"><<a href="mailto:joe@tsolucio.com" target="_blank">joe@tsolucio.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I can confirm this works correctly in 5.4.0 (just tried).
<div>
<div><br>
<br>
<br>
On 10/10/12 19:14, Adam Heinz wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I can use detail and edit view just fine, but if I
attempt to use list<br>
view with a custom filter containing both uitype 52
"Assigned To" and<br>
uitype 101 "Approved By", I get a fatal error. I'm
still on 5.2.1,<br>
but I'm happy to report that 5.3.0 has been merged
into our trunk and<br>
is getting hammered into shape. ;)<br>
<br>
On Wed, Oct 10, 2012 at 1:07 PM, Joe Bordes <<a href="mailto:joe@tsolucio.com" target="_blank">joe@tsolucio.com</a>>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
What problem are you having? I use 101 regularly on
my projects<br>
</blockquote>
</blockquote>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>