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 |
Notes #
- Fulltext search, WordPress media library integration, dynamic hyperlinks, geolocation search and other table or view related features are not supported for custom queries. To use these features, create a view from your custom query and use the Data Explorer Settings tab to enable the desired features for your view.
