Hi,
I add some custom fields in Document module and create a report with these new fields.
When I launch report, I have error like this :
Unknown column 'vtiger_notescf.cf_731' in 'field list'
How could I resolve it ?
Thanks
Very good and quick.
Thanks.
Hello,
I have a new error in report :
Echec de la génération du rapport!
Unknown column 'vtiger_contactdetailsRelServices793.firstname' in 'field list'
How could I solve it ?
Thanks
First: detail the selected modules and columns
Second: go to global variables, and set to 1 the variable Debug_Report_query, then launch the report again, you will get the query on screen, paste it here.
(04-15-2016, 04:59 PM)joebordes Wrote: [ -> ]First: detail the selected modules and columns
Second: go to global variables, and set to 1 the variable Debug_Report_query, then launch the report again, you will get the query on screen, paste it here.
Hi,
I set Debug_Report_Query to 1 and launched the report again : nothing more than :
Unknown column 'vtiger_contactdetailsRelServices793.firstname' in 'field list'
Gérald
That is odd. Did you set the variable to your user?
In any case, please detail the selected modules and columns or try to reproduce in the online demo so I can see it.
Thanks, Gerald.
I've seen that exist two errors.
1.- Your error is because of you have created a relational custom field with Contacts in Products, and the query that is generated fail.
2.- Products by default have in "More Information" tab the related list with contacts, if you want to see this list in the report, you have select the related module "Contacts" in step 2, but if I try this report not fail but not show me any value from contacts.
We will fix it and update coreBOS asap
Hello Omar,
I chose contacts as related module in step 2 but not better.
Thanks for investigating.