[Vtigercrm-developers] multiple user picklists

[Joe Bordes]

If you only need one more user field, use uitype 101


On 10/10/12 17:24, Adam Heinz wrote:
> All entities use the uitype 52 user picklist for Assigned To.  I
> thought I'd reuse that uitype for a second Approved By user picklist.
> Ends up that if you add both fields to a custom view, you get
> fireworks.  The QueryGenerator (at least in 5.2.1) doesn't use table
> aliases, so you end up with SQL that joins against vtiger_users twice.
>
> ERROR 1066 (42000): Not unique table/alias: 'vtiger_users'
>
> Is there a fix for this in a later version, or am I patching QueryGenerator?
> _______________________________________________
> http://www.vtiger.com/