#580 - DB error on module name select
in function action_GetRecord()
$query = "SELECT id, $field_name AS name FROM $table WHERE deleted = 0";
the log is: Query Failed: SELECT id, name AS name FROM users WHERE deleted = 0: MySQL error 1054: Unknown column 'name' in 'field list'
because there is no field called name in the module Users.
i have this problem with other modules like Documents and all my custom modules with a document base.
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.