Create data tables from custom queries (requires a premium license).
Supports #
- Any SQL query (that results in a table. Commands that don’t result in a table are not applicable.)
- Global search
- Search Panes
- Search Builder
- Export and custom buttons
- Advanced options
Usage #
- In Data Tables
- Select Custom query in Publication Data panel
- Enter SQL query or use the Query Builder button to select an existing query
- Save
Inline demo #
Here is the result from the custom query above.
| Department | #Employees | Total Salary | Average Salary |
|---|---|---|---|
| Department | #Employees | Total Salary | Average Salary |