Table

Table

1. Enter name and description of table.
2. Paste an SQL query in the SQL box. It cannot exceed 8000 characters. Right-click and select Edit in SQL Editor command from the menu if you want to edit SQL query in editor.

​​

3. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data.After selecting this option, click Apply SQL. You have to click it also whenever you change an SQL query.
   
   
    
4. Click Apply SQL.
5. Set filter in order to filter data by set criteria. You can select filter from all columns on SQL query. Take care to set criteria wisely. Typically, the filter is equivalent to the WHERE statement in SQL query.

6. Check Use "Total" if you want to use total member in filter.

7. If you would like to open register on double click, you can select register with double click on individual cell. If you reapply SQL (see step 3), you have to define these settings again.

8. To set hyperlink to table, right-click on table header in preview window and click Add hyperlink.

9. Click to confirm it.
   
   

If you change the SQL statement on the existing element ad you skip clicking button Apply SQL, the following message will appear. By confirming this message, data will be automatically reloaded as if you would click Apply SQL.