[Vtigercrm-developers] Ticket 5449 - Two UIType 10s to same module break reports

[filippo spera]

Hi Alan,
below my email with similar question, but no answer at that time.
The issue is still there

Regards
Filippo


=================================
---------- Forwarded message ----------
From: filippo spera <sviluppovtiger at gmail.com>
Date: 2012/9/7
Subject: Fwd: report Issue with UI10
To: vtigercrm-developers at lists.vtigercrm.com


Just to be more clear,

I've tried to build the report adding all the UI10 field to see if the
problem is the same and I discover that:

if the related field is linked to Contact or Account module, the report is
working

but

if the related field is linked to Vendor, Asset or Project Module ( maybe
also to other) I receive similar error.

Thanks
Filippo


---------- Forwarded message ----------
From: filippo spera <sviluppovtiger at gmail.com>
Date: 2012/9/6
Subject: report Issue with UI10
To: vtigercrm-developers at lists.vtigercrm.com



Hi all,

I've a field of Potential in relation with Asset module, the field has been
set as UI10, when I try to build a report and I include such field I get
the following error:

Unknown column 'vtiger_assetsRelPotentials641.assetname' in 'field list'


looks like the report is expectng a table with the name of the related
field (fieldid 641).

Have You seen that before? have You find a solution or a workaround?



Regards

Filippo



=================================


2013/4/30 Alan Lord <alanslists at gmail.com>

> On 28/04/13 16:31, Alan Lord (News) wrote:
>
>> Am pretty sure this isn't fixed...
>>
>> http://trac.vtiger.com/cgi-**bin/trac.cgi/ticket/5449<http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/5449>
>>
>>
> Is anyone else able to confirm this?
>
> To re-cap: I have a vtlib custom module with TWO UIType 10s to Contacts, a
> UIType 10 to Vendors and a UIType 10 to Organisations.
>
> I can create reports on my custom module OK, but if I try and create a
> report on either Organisations or Vendors and include the my related custom
> module the report fails because of not unique aliases on Contacts.
>
> TIA
>
> Al
>
>
>
> ______________________________**_________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130430/e7ce8824/attachment.html>