Tweet
Hello!
I'm trying to build a report on contacts.
In the conditions I choose accounts.target_list_id (choose the goal)
When you click on the save button, you get an error:
Server side error 200: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accounts.target_list_id' in 'where clause'
Response:
{"id":"594a9885ead4a2edc","name":"2222222222","del eted":false,"type":"List","data":null,"columns":["name"],"groupBy":null,"orderBy":null,"orderByList":"","f ilters":null,"filtersDataList":[{"id":"573b51c176058","name":"accounts.targetList" ,"params":{"type":"equals","field":"accounts.targe tListId","value":"594a9806c4d20d372","valueName":" 11111","data":{"type":"is"},"attribute":"accounts. targetListId"}}],"runtimeFilters":[],"filtersData":null,"columnsData":{"name":{"link": true,"width":null,"notSortable":false,"align":"lef t"}},"chartColorList":null,"chartColors":null,"cha rtColor":"#6FA8D6","description":"","chartType":nu ll,"depth":null,"isInternal":false,"internalClassN ame":null,"createdAt":"2017-06-21 16:02:13","modifiedAt":"2017-06-21 16:10:55","emailSendingInterval":"","emailSendingS ettingMonth":null,"emailSendingSettingDay":null,"e mailSendingSettingWeekdays":null,"emailSendingTime ":null,"emailSendingLastDateSent":null,"emailSendi ngDoNotSendEmptyReport":false,"createdById":"1","c reatedByName":"Admin","modifiedById":"1","modified ByName":"Admin","assignedUserId":"1","assignedUser Name":"Admin"}
Tried to do on the demo version, same thing.
I'm trying to build a report on contacts.
In the conditions I choose accounts.target_list_id (choose the goal)
When you click on the save button, you get an error:
Server side error 200: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'accounts.target_list_id' in 'where clause'
Response:
{"id":"594a9885ead4a2edc","name":"2222222222","del eted":false,"type":"List","data":null,"columns":["name"],"groupBy":null,"orderBy":null,"orderByList":"","f ilters":null,"filtersDataList":[{"id":"573b51c176058","name":"accounts.targetList" ,"params":{"type":"equals","field":"accounts.targe tListId","value":"594a9806c4d20d372","valueName":" 11111","data":{"type":"is"},"attribute":"accounts. targetListId"}}],"runtimeFilters":[],"filtersData":null,"columnsData":{"name":{"link": true,"width":null,"notSortable":false,"align":"lef t"}},"chartColorList":null,"chartColors":null,"cha rtColor":"#6FA8D6","description":"","chartType":nu ll,"depth":null,"isInternal":false,"internalClassN ame":null,"createdAt":"2017-06-21 16:02:13","modifiedAt":"2017-06-21 16:10:55","emailSendingInterval":"","emailSendingS ettingMonth":null,"emailSendingSettingDay":null,"e mailSendingSettingWeekdays":null,"emailSendingTime ":null,"emailSendingLastDateSent":null,"emailSendi ngDoNotSendEmptyReport":false,"createdById":"1","c reatedByName":"Admin","modifiedById":"1","modified ByName":"Admin","assignedUserId":"1","assignedUser Name":"Admin"}
Tried to do on the demo version, same thing.
Comment