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.
#4613 - Regarding Report Enhancer Plugin
Hi, When creating a report, I choose some columns to be viewed. Report show results. When adding a simple SQL query, such as " When country_c <> ' ' or " select * from cases where name is not null " I do not get any results at all.
a year ago
Greetings, Try using the LIMIT clause in queries on large tables with thousands of records or impose additional where conditions to limit the size of the result set being returned. Also, take a look at the suitecrm.log of your instance for other underlying issues cause by queries. Thanks and hope this helps.