CoreBOSBB › Development › coreBOS Development v
Having trouble with a report

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Having trouble with a report
Guido1982 Offline
Posting Freak
*****
Posts: 855
Threads: 238
Joined: Nov 2015
Reputation: 96
#1
10-15-2016, 08:09 AM
Having trouble with a report I want to use, that lists all timecontrol records from a certain report. The error is:

" Unknown column 'vtiger_projectRelProjectTask637.projectname' in 'where clause' "

Anybody have some tips on where to look in the code?
Find
Reply
joebordes Offline
Administrator
*******
Posts: 3,565
Threads: 36
Joined: Apr 2014
Reputation: 49
#2
10-17-2016, 09:12 PM
The first thing you can do is set the global variable DEBUG_ReportQuery to 1 and analyze the SQL.
I suppose the problem will be in the GenerateReport() methods in Projects if they exist.
I created a report with some TC columns and Project Name, it worked correctly. Can you reproduce the problem in the online demo? Can you give me some more information on how to reproduce it?
Joe
TSolucio
Find
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)