[Vtigercrm-developers] multiple user picklists

Joe Bordes joe at tsolucio.com
Fri Apr 12 19:20:26 UTC 2013


Glad that helped :-)

Have a nice weekend (all)

Joe
TSolucio



El 12/04/13 18:30, Adam Heinz escribió:
> 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 
> <mailto: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
>     <mailto: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
>>         <mailto: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 <mailto: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/
>
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130412/9a25cc7a/attachment-0001.html>


More information about the vtigercrm-developers mailing list