can't find SQL executer and can use sql in operation permissions doesn't exist

Hi Ibrahim,

Unfortunately, the SQL query console plugin is not supported anymore. As of now there are no alternatives but we are working on creating one. You can send the scripts you need to execute to our support address support@creatio.com and we will run them for you!

Best regards,

Max.

I am currently working on a new marketplace add-on for this as well.

For now, if you have the previous SQL Executor add-on in another system, you can export the package from the configuration to install into another system.

Ryan

Ryan Farley,

wondering if you have already created something useable, because the old SQL console is not really working anymore in the latest releases.

I'd be happy to contribute either with testing or development!

Thanks for your effort!

Ryan Farley,

Ditto, I'd be happy to contribute either with testing or development!

Gareth Osler,

We have built an new query tool for FreedomUI that provides the same ability as the legacy SQL Executor app. Would you be interested in trying it out during our beta test phase?

Allen Dsouza,

Hi, I'm interested

Is there anything released for this yet? Ideally something first party to simplify things licencing and security-wise. We are having some troubles trying to have support run some of our scripts, as they need to be run in a certain way due to Postgres' transaction rules.

Harvey Adcock,

I started something for this as well, but stopped working on it since I now use Clio Explorer for executing SQL for Creatio. It's a great route IMO - i just wish it handled SQL errors better. As of now it tells you there was an error but does not provide any details of what the error was (I created an issue for Clio for this, but haven't seen any responses). Still a great way to use SQL queries for Creatio since you can save the query files for later reuse.

Allen Dsouza,

We would be interested in Beta testing this as well