Skip to content

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

License

Notifications You must be signed in to change notification settings

kenbrill/sqlViewer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

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

Resources

License

Stars

Watchers

Forks

Packages

No packages published