<div dir="ltr">Ok! Your patch did not fix the issue, but it gave me insight into that section of the QueryGenerator, which lead to a fix! I've mentioned before that we use uitype 52 (user) instead of uitype 53 (user or group) for entity ownership. Ends up that 52 is marked as 'reference' type and 53 is marked as 'owner' type. I changed the row in vtiger_ws_fieldtype and set one of my two fields to uitype 101 as you suggested and voila! Thanks!</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Apr 12, 2013 at 10:58 AM, Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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"><div><div class="h5">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>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<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>
<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></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
</blockquote></div><br></div>