Ad hoc Query
The objective of this feature is to make the users more powerful with the kind of insights they can extract from their assessments. This breakthrough feature provides limitless capability to extract custom insights through simple SQL queries. This is the first time we’ve introduced such a feature where users can explore new dimensions and thus unleash new opportunities. With all the knowledge base existing in the scripts, query execution logs and more, you can now query and attain new insights.
To access the Ad hoc Query page, you must log in to LeapLogic after creating an account (see Prerequisites for more details) and then select Assessment > Ad hoc Query on the left navigation pane.
To export a custom report, follow the below steps:
- In Query, provide a custom-built SQL query to extract insights.
- In Reference Metadata, upload CSV file(s) which act as a metadata reference for extracting the required insights.
Refer to the sample template below for more information.
- Click
to export the custom report.
The downloaded custom report contains specific insights related to the provided custom-build SQL query.
Leaplogic