StdSqlEditor

SQL Statements

This app allows you to store SQL statements that can be used in all the apps of a workspace.

In the main editor window you can edit the SQL statement. It is always good practice to add a brief description for your statement. This description is searchable within the statement list.

In addition test parameter can be supplied. Test parameter must use Json format.

Example Usages

select * from ExampleDataBase where ExampleCountryCode = @country and ExampleZipCode = @zip

Test parameter for the above statement

{"zip":"12345", "country":"DE"}

Demo