[Vtigercrm-developers] multiple user picklists

[Adam Heinz]

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!


On Fri, Apr 12, 2013 at 10:58 AM, Adam Heinz <amh at metricwise.net> wrote:

> It looks like you've made a small change; attached as a patch.  Testing
> now.
>
>
> On Fri, Apr 12, 2013 at 10:39 AM, Joe Bordes <joe at tsolucio.com> wrote:
>
>>  Hi Adam,
>>
>> I just tried it (again) in our online Timecontrol/Payment demo install:
>>
>>
>> http://crmevolutivo.com/vt_timecontrol54/index.php?action=index&parenttab=Inventory&module=CobroPago&viewname=69
>>
>> I created a list view for payments showing assigned to and uitype 101 and
>> it seems to work
>>
>> 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.
>>
>> Joe
>> TSolucio
>>
>>
>> El 12/04/13 16:24, Adam Heinz escribió:
>>
>> 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?
>>
>>  [1]
>> http://trac.vtiger.com/cgi-bin/trac.cgi/browser/vtigercrm/branches/5.4.0/include/QueryGenerator/QueryGenerator.php#L327
>>
>>
>> On Wed, Oct 10, 2012 at 1:47 PM, Joe Bordes <joe at tsolucio.com> wrote:
>>
>>> I can confirm this works correctly in 5.4.0 (just tried).
>>>
>>>
>>>
>>> On 10/10/12 19:14, Adam Heinz wrote:
>>>
>>>> I can use detail and edit view just fine, but if I attempt to use list
>>>> view with a custom filter containing both uitype 52 "Assigned To" and
>>>> uitype 101 "Approved By", I get a fatal error.  I'm still on 5.2.1,
>>>> but I'm happy to report that 5.3.0 has been merged into our trunk and
>>>> is getting hammered into shape.  ;)
>>>>
>>>> On Wed, Oct 10, 2012 at 1:07 PM, Joe Bordes <joe at tsolucio.com> wrote:
>>>>
>>>>> What problem are you having?  I use 101 regularly on my projects
>>>>>
>>>>
>>>
>>
>>
>> _______________________________________________http://www.vtiger.com/
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130412/ee425f21/attachment.html>