Add new SQL query

Description

This page allows to create or edit SQL query. Created SQL queries are shown in SQL Manager page.

Add new SQL query User Interface

Common components

• E-commerce logo.

• PrestaShop version number.

• Quick access dropdown.

• Search input - Forms input with dropdown UI kit.

• Bell icon (todo link)

• Account icon.

• Shop switcher.

• Breadcrumbs navigation - Breadcrumb UI kit.

• Heading of the page - Headings UI kit.

• Help button - Buttons outline UI kit.

• Save button - Buttons basics UI kit.

• Cancel button - Buttons outline UI kit.

The UI elements

SQL query name input

Description	Value	Error message
Mandatory	Yes	-
Allowed/Forbidden values	-	-
Default value	-	-
Help text	-	-
Tool tips	-	-
Lower limit	-	-
Upper limit	-	-
Behavior	link to the behavior	-

SQL query input

Description	Value	Error message
Mandatory	Yes	-
Allowed/Forbidden values	-	-
Default value	-	-
Help text	-	-
Tool tips	-	-
Lower limit	-	-
Upper limit	-	-
Behavior	link to the behavior	-

List of MySQL Tables dropdown

Description	Value	Error message
Mandatory	No	-
Allowed/Forbidden values	-	-
Default value	-	-
Help text	-	-
Tool tips	List of MySQL table	-
Lower limit	-	-
Upper limit	-	-
Behavior	link to the behavior	-

Behaviors description

Notification message behavior

This is blue alert message (Alerts basics UI kit) and it is: Note that this feature is available in all shops context only. It will be added to all your stores.

SQL query block behavior

This block contains two mandatory input fields:

• SQL query name input

• SQL query input

SQL query name input behavior

This is a field (Forms normal UI kit) to enter SQL query name.

SQL query input behavior

This is a field (Forms normal UI kit) to enter SQL query.

List of MySQL Tables block behavior

This block contains these elements:

• List of MySQL Tables dropdown

• Add table name to SQL query button

List of MySQL Tables dropdown behavior

This is dropdown (Dropdowns basics UI kit) of MySQL tables to select MySQL table.

Add table name to SQL query button behavior

This is CTA button with plus icon (Buttons with icons UI kit), once clicked it adds selected MySQL table title to SQL query input.

List of attributes for this MySQL table block behavior

By default this block is empty and has blue alert message (Alerts basics UI kit) and it is: Please choose a MySQL table

When select MySQL table in List of MySQL Tables dropdown its attributes are shown in this block list. Each attribute has name, type and Action columns.

Multistore functionality

Multistores independent page.