{"_id":"@7span/directus-extension-custom-query-panel","_rev":"2-ebfc50ff94cfe31e0298b2acb5c35cbe","name":"@7span/directus-extension-custom-query-panel","dist-tags":{"latest":"1.1.6"},"versions":{"1.1.4":{"name":"@7span/directus-extension-custom-query-panel","version":"1.1.4","scripts":{"build":"directus-extension build","dev":"directus-extension build -w --no-minify","link":"directus-extension link","add":"directus-extension add"},"directus:extension":{"host":"^9.22.4","type":"bundle","path":{"app":"dist/app.js","api":"dist/api.js"},"entries":[{"type":"panel","name":"custom-query-panel","source":"src/custom-query-panel/index.js"},{"type":"endpoint","name":"custom-query","source":"src/custom-query/index.js"}]},"devDependencies":{"@directus/extensions-sdk":"9.22.4","vue":"^3.2.47"},"author":{"name":"7span","email":"yo@7span.com"},"repository":{"type":"git","url":"git+https://github.com/7span/directus-extension-custom-query-panel.git"},"homepage":"https://github.com/7span/directus-extension-custom-query-panel#Readme","publishConfig":{"access":"public"},"dependencies":{"dotenv":"^16.3.1","paraphrase":"^3.1.1"},"gitHead":"25c33b4f9d052cf55b530cdcb0f5a13ae39e20c5","description":"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! πŸ’ΎπŸŽ‰","bugs":{"url":"https://github.com/7span/directus-extension-custom-query-panel/issues"},"_id":"@7span/directus-extension-custom-query-panel@1.1.4","_nodeVersion":"18.17.0","_npmVersion":"9.6.7","dist":{"integrity":"sha512-YHmRZ80yxOIdWfiWAZXzuS3Fbh4VTKRwAj/9DtfqVntZi3MPoZlOEbnXepA4dwrcO8/dHQOq7rR8LmwPdftRhw==","shasum":"50855a550151796d2772b15c02765eff43bdb990","tarball":"https://registry.npmjs.org/@7span/directus-extension-custom-query-panel/-/directus-extension-custom-query-panel-1.1.4.tgz","fileCount":11,"unpackedSize":1013422,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCRQoDwmLFVWHE6ExXOjqE2TTlQmpcx3gGLp0b4FgInwwIgaEqwO6dJZ8WpaXwPpcYkQ9kw/nhEi/MSeoj2dcZ655M="}]},"_npmUser":{"name":"theharsh","email":"mail@theharsh.in"},"directories":{},"maintainers":[{"name":"theharsh","email":"mail@theharsh.in"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/directus-extension-custom-query-panel_1.1.4_1701243946608_0.9228779882367637"},"_hasShrinkwrap":false},"1.1.5":{"name":"@7span/directus-extension-custom-query-panel","version":"1.1.5","scripts":{"build":"directus-extension build","dev":"directus-extension build -w --no-minify","link":"directus-extension link","add":"directus-extension add","prepublishOnly":"npm run build"},"directus:extension":{"host":"^9.22.4","type":"bundle","path":{"app":"dist/app.js","api":"dist/api.js"},"entries":[{"type":"panel","name":"custom-query-panel","source":"src/custom-query-panel/index.js"},{"type":"endpoint","name":"custom-query","source":"src/custom-query/index.js"}]},"devDependencies":{"@directus/extensions-sdk":"9.22.4","vue":"^3.2.47"},"author":{"name":"7span","email":"yo@7span.com"},"repository":{"type":"git","url":"git+https://github.com/7span/directus-extension-custom-query-panel.git"},"homepage":"https://github.com/7span/directus-extension-custom-query-panel#Readme","publishConfig":{"access":"public"},"dependencies":{"dotenv":"^16.3.1","paraphrase":"^3.1.1"},"gitHead":"25c33b4f9d052cf55b530cdcb0f5a13ae39e20c5","description":"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! πŸ’ΎπŸŽ‰","bugs":{"url":"https://github.com/7span/directus-extension-custom-query-panel/issues"},"_id":"@7span/directus-extension-custom-query-panel@1.1.5","_nodeVersion":"18.17.0","_npmVersion":"9.6.7","dist":{"integrity":"sha512-OtTWMgRXHOftyYuvMtlV1yTF0ID/UWbf5B7/QlZUFpEGmwd/H8Ozd5Gtl8MU1qsZkaQKtbzcFyWRC9sy4JzeVQ==","shasum":"9ca91eb2199855da9e9a5966fc93a3d2e2ea627e","tarball":"https://registry.npmjs.org/@7span/directus-extension-custom-query-panel/-/directus-extension-custom-query-panel-1.1.5.tgz","fileCount":4,"unpackedSize":16567,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDXq2mLrh4Oox9vdbhFbfH3KWPr7a0Iu1ntUoce85Q+7AiEAz5/xJk1ta1+b0/4e7WInxiAfbtpdT0/lsHr+9GGiX0E="}]},"_npmUser":{"name":"theharsh","email":"mail@theharsh.in"},"directories":{},"maintainers":[{"name":"theharsh","email":"mail@theharsh.in"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/directus-extension-custom-query-panel_1.1.5_1701244524123_0.38482098495372674"},"_hasShrinkwrap":false},"1.1.6":{"name":"@7span/directus-extension-custom-query-panel","version":"1.1.6","scripts":{"build":"directus-extension build","dev":"directus-extension build -w --no-minify","link":"directus-extension link","add":"directus-extension add","prepublishOnly":"npm run build"},"directus:extension":{"host":"^9.22.4","type":"bundle","path":{"app":"dist/app.js","api":"dist/api.js"},"entries":[{"type":"panel","name":"custom-query-panel","source":"src/custom-query-panel/index.js"},{"type":"endpoint","name":"custom-query","source":"src/custom-query/index.js"}]},"devDependencies":{"@directus/extensions-sdk":"9.22.4","vue":"^3.2.47"},"author":{"name":"7span","email":"yo@7span.com"},"repository":{"type":"git","url":"git+https://github.com/7span/directus-extension-custom-query-panel.git"},"homepage":"https://github.com/7span/directus-extension-custom-query-panel#Readme","publishConfig":{"access":"public"},"dependencies":{"dotenv":"^16.3.1","paraphrase":"^3.1.1"},"gitHead":"437209eab2599cbcf3ea574ace72218fa9f81f97","description":"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! πŸ’ΎπŸŽ‰","bugs":{"url":"https://github.com/7span/directus-extension-custom-query-panel/issues"},"_id":"@7span/directus-extension-custom-query-panel@1.1.6","_nodeVersion":"18.17.0","_npmVersion":"9.6.7","dist":{"integrity":"sha512-JIf4Qf2H57C5OExsGQ3bwHBb5CJI5uW1rGR50/S5rwMAU3PFerNeriemnTi6IiwhUCjssMjw9WwdAEhyCI7jOQ==","shasum":"db6236d8d7e51a66d14fc8c5ec7225da6961565e","tarball":"https://registry.npmjs.org/@7span/directus-extension-custom-query-panel/-/directus-extension-custom-query-panel-1.1.6.tgz","fileCount":4,"unpackedSize":16404,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC3rlLJU5CvJ6UHsek/34dJWPi6dbMDcWYEFNZRdspw3wIhAJGYPedf2/WKui7AiAAuYB/JS3kiitLgLwEyN9lZ+p5m"}]},"_npmUser":{"name":"theharsh","email":"mail@theharsh.in"},"directories":{},"maintainers":[{"name":"theharsh","email":"mail@theharsh.in"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/directus-extension-custom-query-panel_1.1.6_1701259257973_0.9099650959530792"},"_hasShrinkwrap":false}},"time":{"created":"2023-11-29T07:45:46.503Z","1.1.4":"2023-11-29T07:45:46.948Z","modified":"2023-11-29T12:00:58.338Z","1.1.5":"2023-11-29T07:55:24.501Z","1.1.6":"2023-11-29T12:00:58.122Z"},"maintainers":[{"name":"theharsh","email":"mail@theharsh.in"}],"description":"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! πŸ’ΎπŸŽ‰","homepage":"https://github.com/7span/directus-extension-custom-query-panel#Readme","repository":{"type":"git","url":"git+https://github.com/7span/directus-extension-custom-query-panel.git"},"author":{"name":"7span","email":"yo@7span.com"},"bugs":{"url":"https://github.com/7span/directus-extension-custom-query-panel/issues"},"readme":"# Directus Custom Query Panel\n\nBehold 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! πŸ’ΎπŸŽ‰\n\n\n## Details\n\n- Execute custom SQL queries directly from the panel.\n- Use dynamic parameters to reuse queries with different values.\n- Display query results in a simple tabular structure for easy readability.\n- Enhance data visibility and understanding by enabling users to extract meaningful insights from their data which is crucial for CRM and data-driven applications.\n\n\n## πŸ‘€Set Up Instructions\n\n- Either install through NPM [npm install @7span/directus-extension-custom-query-panel](https://www.npmjs.com/) or [Installing Through the Extensions Folder](https://docs.directus.io/extensions/installing-extensions.html#installing-through-the-extensions-folder).\n- Once Installed/configured extension you need hit the below curl request to create a default table(`cqp_queries`) to store the queries.\n\n**NOTE**: Replace `localhost:8055` with your domain\n\n```bash\ncurl --location --request POST 'http://localhost:8055/custom-query-panel/create-table'\n```\n\n- Table named `cqp_queries` will be available in your project.\n\n## How To use This Extension\n\n1. Create the queries in the table (`cqp_queries`) as explained in below example.\n\n```bash\nselect first_name, last_name from employees where department = ${department} \n```\n\n\n2. This extension provides support of *`global variables`* added in insights like department or week.\n\n\n3. Use `variables` field give in panel settings below `fields`.\n\n\n4. Use `double mustache` syntax for entering `value` field to get value from variables.\n\n\n## πŸ‘€ Environment Variables\n- You can provide collection name in CUSTOM_QUERY_COLLECTION as per your needs.\n- It Also provide support for custom query length using CUSTOM_QUERY_FIELD_LENGTH\n```bash\n# default value CUSTOM_QUERY_COLLECTION = \"cqp_queries\" \nCUSTOM_QUERY_COLLECTION=\"custom_query\"\n# default value CUSTOM_QUERY_FIELD_LENGTH = 5000 \nCUSTOM_QUERY_FIELD_LENGTH=10000\n```\n\n\n## Problem\n\n- Getting data from database query and show it in a insights panel was missing.\n\n- The ability to extract and display data from a database query within an insights panel is crucial for CRM and data-driven applications.\n- Insights panels serve as a hub for users to access valuable information, gain actionable insights, and make informed decisions.\n- 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.\n\n## Extension Type\n\n- πŸ“¦ Bundle ( Panel + Custom Endpoint )\n\n## Screenshots\n\n![Add Query](/images/add-query.png)\n![Department Example](/images/department-panel.png)\n![dynamic-fields](/images/dynamic-fields.png)\n![Adding File Label](/images/file-label.png)\n![Alt text](/images/double-mustache.png)\n## Collaborators\n\n- [Harsh Kansagara](https://github.com/theharshin)\n- [Jay Bharadia](https://github.com/jay-p-b-7span)\n- [Bhagyesh Radiya](https://github.com/bhagyesh-7span)\n\n## Contact Details\n\n- [Linkedin](https://www.linkedin.com/company/7span)\n- [Gmail](mailto:yo@7span.com)\n\n## 🚧 Please note\n\n- this extension uses raw query. Use with caution. It might do uninteded actions.\n- Roles and permission check for query\n\n### Table Fields\n\n- We have repeater interface with multiple columns support\n\n","readmeFilename":"Readme.md"}