# HTML

The HTML portlet allows the usage of HTML code inside the portal. It can execute SQL queries and use the result with HTML to get a customized presentation of the data. 

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u58EzztZrwGDQJrZ8%2Fhelp_root_clients_portal_portlets_html_htmlMain.png?alt=media\&token=9908c1ec-5e30-4f85-9fe7-569422bda937)

### Basic Data

**Internal name** - unique string to identify this portlet.\
**Portlet title** - title of the portlet, does not have to be unique. 

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u5BPlz1w2QeN4GaJh%2Fhelp_root_clients_portal_portlets_html_htmlBasic.png?alt=media\&token=09713a05-2954-4f55-93b0-7e18c9c85266)

### HTML Template

The HTML template is where the user can customize how the portlet will be displayed. It supports HTML5.

**Header** - format the html portlet with a header. Can take in variables from the SQL query e.g. "*Welcome {name}*" where {name} is fetched from the SQL query.\
 **Body** - format the html portlet with a body. Can also take in variables from the SQL query. 

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u5Ednutfq8OHHWH6L%2Fhelp_root_clients_portal_portlets_html_htmlTemplate.png?alt=media\&token=55be9cb8-27ad-4c96-8bb5-2dcae4309a44)

### Auto Refresh

Auto Refresh enables the portlet to refresh the data every SS:second. 

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u5H70-nJfKmqg_g_T%2Fhelp_root_clients_portal_portlets_html_autorefresh.png?alt=media\&token=7c6c929d-34ee-45e5-adb2-d2332fe81f61)

### Query Configuration

Query Configuration enables the portlet to execute specified queries towards the chosen database connector.

* **Database connector** - Select which connector that the query will execute against.
* **Your query** - Text field where queries can be written
* **Page Size** - Amount of rows showed on each page

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u5LGXJPVzwNCQtQ9l%2Fhelp_root_clients_portal_portlets_html_htmlQuery.png?alt=media\&token=78f8a81c-06d7-4402-8789-10f1819c1d45)

### Commands

Commands enables the portlet to listen for events sent by other portlets to execute specified commands. **The portlet will listen to the following commands**

* onRowSelected
* onGenericTreeNodeSelected
* onRefresh
* onFilter

**The portlet will listen to the following portlets** *Specify which portlet the commands above will trigger from*. The portlets that appears will be shown with their unique internal name. 

![](https://543770944-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M-u4sEkqEHv93_ffdO5%2F-M-u5Nc9g-lAOckiDquJ%2Fhelp_root_clients_portal_portlets_html_htmlCommands.png?alt=media\&token=0fd78ac3-3f57-4033-94ce-98bbda46284c)