<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Glad that helped :-)<br>
<br>
Have a nice weekend (all)<br>
<br>
Joe<br>
TSolucio<br>
<br>
<br>
<br>
El 12/04/13 18:30, Adam Heinz escribió:<br>
</div>
<blockquote
cite="mid:CAKBdvM_KCOVbmwcfTNDOS6TJR0pmC-fAaX2LNSVNUsKitW2f4A@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true" href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a moz-do-not-send="true"
href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.vtiger.com/">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</body>
</html>