brixxbox Wiki
Search
⌃K

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