Lets Administrators query mySQL or MSSQL instances of their suiteCRM databases directly. Browse and export cloud-hosted and local data quickly and easily. Turn results into graphic charts with a single click.
#4007 - No result return
Hi, I'm using the trial version, the "SQL Query" did not return any results, but the same SQL statement works on MySQL Workbench.
itregister
2 years ago
Greetings, Most often the suitecrm.log shows SQLQuery errors and hence no results returned. Did you try the sample demo queries?
2 years ago
Yes, we did. No result return. We are using SuiteCRM 7.12
2 years ago
how to assign an SQLQuery role to a non-admin user??
2 years ago
Greetings, We are going to get back to with our tests with version 7.12. Do you see any errors in the suitecrm.log file? Please see https://store.suitecrm.com/docs/SQLQuery/user-guide for assigning an SQLQuery role to a non-admin user.