v1.1.0 — Fixed and working version

v1.1.0 – Safer and More Usable Creatio SQL Console

This release focuses on improving safety, usability, and visual clarity of the in-app SQL Console.

Backend changes

• Added permission check via a dedicated system operation CanUseSQLConsole
  Only users with this operation can execute queries from the console.
• Introduced a hard limit of 5000 rows for SELECT queries.
  If the result set exceeds this limit, the service returns a clear error message instead of streaming all rows.
• Implemented query logging: every unique SQL text is saved to the iaSQLConsole table together with the user and timestamp.
• Added a basic SQL safety filter that blocks dangerous commands:
  • DROP
  • DELETE
  • TRUNCATE
    (and related variations)
    These commands are not executed via the console.
• Simplified the service API to accept raw queryText (unencrypted) directly from the UI.

Frontend changes

• Added client-side column sorting:
  • click a column header to sort ascending,
  • click again to toggle descending,
  • clicking another column switches sorting to that column.
• Improved table styling for better readability:
  • dark grey header with white text,
  • alternating grey/white row background (striped table),
  • subtle grid lines between rows and columns.
• Kept support for:
  • pagination,
  • date formatting for /Date(...) values,
  • CSV export for query results.

Safety note

This tool is still powerful and is intended primarily for development / non-production environments.
For production, use it with extreme care and only for trusted technical users with the proper operation assigned.