Behold the magic 🎩✨ of our simple panel! View your data without the hassle of writing custom endpoints or preparing views - it's like having your cake 🍰 and eating it too, but for data! 💾🎉
- Execute custom SQL queries directly from the panel.
- Use dynamic parameters to reuse queries with different values.
- Display query results in a simple tabular structure for easy readability.
- Enhance data visibility and understanding by enabling users to extract meaningful insights from their data which is crucial for CRM and data-driven applications.
- Either install through NPM npm install @7span/directus-extension-custom-query-panel or Installing Through the Extensions Folder.
- Once Installed/configured extension you need hit the below curl request to create a default table(
cqp_queries
) to store the queries.
NOTE: Replace localhost:8055
with your domain
curl --location --request POST 'http://localhost:8055/custom-query-panel/create-table'
- Table named
cqp_queries
will be available in your project.
- Create the queries in the table (
cqp_queries
) as explained in below example.
select first_name, last_name from employees where department = ${department}
- This extension provides support of
global variables
added in insights like department or week.
- Use
variables
field give in panel settings belowfields
.
- Use
double mustache
syntax for enteringvalue
field to get value from variables.
- You can provide collection name in CUSTOM_QUERY_COLLECTION as per your needs.
- It Also provide support for custom query length using CUSTOM_QUERY_FIELD_LENGTH
# default value CUSTOM_QUERY_COLLECTION = "cqp_queries"
CUSTOM_QUERY_COLLECTION="custom_query"
# default value CUSTOM_QUERY_FIELD_LENGTH = 5000
CUSTOM_QUERY_FIELD_LENGTH=10000
-
Getting data from database query and show it in a insights panel was missing.
-
The ability to extract and display data from a database query within an insights panel is crucial for CRM and data-driven applications.
-
Insights panels serve as a hub for users to access valuable information, gain actionable insights, and make informed decisions.
-
This feature bridges the gap between raw data stored in the database and its meaningful interpretation, making Directus an even more versatile platform for managing customer relationships and data-driven business operations.
- 📦 Bundle ( Panel + Custom Endpoint )
- this extension uses raw query. Use with caution. It might do uninteded actions.
- Roles and permission check for query
- We have repeater interface with multiple columns support