SQL Manager
Description
This is page that allows to explore a database using the SQL language.
Common components
Bell icon (todo link)
The UI elements
Add new SQL query button
Description | Value | Error message |
---|---|---|
Mandatory | No | - |
Allowed/Forbidden values | - | - |
Default value | - | - |
Help text | - | - |
Tool tips | Add new SQL query | - |
Lower limit | - | - |
Upper limit | - | - |
Behavior | - |
Setting wheel icon
Description | Value | Error message |
---|---|---|
Mandatory | No | - |
Allowed/Forbidden values | - | - |
Default value | - | - |
Help text | - | - |
Tool tips | Settings | - |
Lower limit | - | - |
Upper limit | - | - |
Behavior | - |
Select your default file encoding dropdown
Description | Value | Error message |
---|---|---|
Mandatory | Yes | - |
Allowed/Forbidden values | - | - |
Default value | utf-8 | - |
Help text | - | - |
Tool tips | - | - |
Lower limit | - | - |
Upper limit | - | - |
Behavior | - |
Behaviors description
Add new SQL query button behavior
This is CTA button with plus icon (Buttons with icons UI kit), once clicked it opens new SQL query creation page. When hover mouse pointer on it, button color changes.
Blue alert message behavior
This is blue alert message (Alerts basics UI kit) and it is: How do I create a new SQL query?
Click "Add new SQL query".
Fill in the fields and click "Save".
You can then view the query results by clicking on the "View" action in the dropdown menu.
You can also export the query results as a CSV file by clicking on the "Export" button.
Yellow alert message behavior
This is yellow alert message (Alerts basics UI kit) and it is: When saving the query, only the "SELECT" SQL statement is allowed.
Title of SQL Manager list behavior
It contains title and number of SQL queries in brackets. by default number in brackets is 0, because no SQL queries are created. In the block instead of list is notification: No records found.
Setting wheel icon behavior
Once clicked this icon opens po up with these options:
Refresh list
Show SQL query
Export to SQL Manager
Title of Settings block behavior
It contains title and setting wheel icon.
Select your default file encoding dropdown behavior
This is dropdown (Dropdowns basics UI kit) choose default file encoding option. There are 2 options in dropdown: utf-8 and iso-8859-1.
Multistores functionality
Multistores dependent page.
Last updated