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.

Basic Data

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

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.

Auto Refresh

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

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

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.