[*] Charts - Charts may have wrong field mapping field to sequelize model.

[Jekiwijaya]

Steps to reproduce

1. Map the model attribute createdAt to field created_at
2. Create line dashboard grouping by createdAt attribute

Expected behavior

Dashboard show no error.

Actual behavior

Dashboard show error SQLITE_ERROR: no such column: User.createdAt

Failure Logs

[forest] 🌳🌳🌳  Unexpected error: SQLITE_ERROR: no such column: User.createdAt
SequelizeDatabaseError: SQLITE_ERROR: no such column: User.createdAt

Context

I think that's because of this line

forest-express-sequelize/services/line-stat-getter.js

Lines 25 to 26 in c51a606

	var fieldName = params['group_by_date_field'];
	return schema.name + '.' + fieldName;

It straight getting the column name from models attribute name, instead of the field option.

• Package Version: 3.2.3
• Express Version: 4.16.2
• Sequelize Version: 4.41.2
• Database Dialect: sqlite
• Database Version:

[arnaudbesnier]

Hi @Jekiwijaya,
Thank you for the feedback.
We'll try to look at your PR this week.