Skip to content

Latest commit

 

History

History
23 lines (17 loc) · 1.06 KB

File metadata and controls

23 lines (17 loc) · 1.06 KB

sqlViewer v1.0

This allows you to recombine a query from your SugarCRM log file into a readable query

You will find the sqlViewer tool on your Admin Menu in the 'System' section Screenshot

When you click on that link it will take you to the main screen. Here you can either paste in a query that you want to work with or click on the 'Retrieve SQL from Log' button. Screenshot

If you click the 'Retrieve SQL from Log' button you will get a listing of every unique SQL query in your sugarcrm.log file. Next to the button on the main screen you are able to set a limit to how many lines the tool shows you. They are sorted Newest to oldest. Screenshot

Once you paste a query or select one from the log you will then see that query formatted, highlighted, and the params moved into place. Screenshot

You can click on the 'Submit and Run Query' button to actually run the query against your database. The tool only runs SELECT queries and will refuse to run an UPDATE, DELETE or other type of query. Screenshot