Hello, I was trying to create reports using the report module but I noticed the query is being wrongly executed.
I set the target module to be accounts and I chose the field created by, I found out the query to be writing accounts
.created_by_name however the field name on the database is created_by
Query Failed: SELECT `accounts`.created_by_name AS 'Created_By0', `accounts`.id AS 'accounts_id' FROM `accounts` WHERE accounts.deleted = 0 LIMIT 0,20: MySQL error 1054: Unknown column 'accounts.created_by_name' in 'field list'