QuickDEV
  • ▶️Quick start
    • 🔃Overview
    • 🔑Security
  • 🎭Users management
    • 👨‍👩‍👦‍👦Members and groups
    • 🔐Permission for resources
  • 🖥️Applications
    • ➕Create applications
      • ⤴️Create application/module
      • 🔲Module
      • ✅Version and Release Management
    • 🎨Application editor
      • 👁️‍🗨️Visual components
        • ⚙️Common component settings
        • ⬆️File upload
        • 📊Charts and graphs
        • 🌄Image
        • 📋Option lists
        • 📑List view
        • ⬜Drawer
        • 🗺️Google maps
        • 📩Messages / Toast
        • 📅Calendar
        • Custom component
      • #️⃣Use markdown
      • ⌨️Keyboard shortcuts
    • 🔗Navigation
    • ⏯️Actions editor
      • ⏱️Date handling
      • 🟰Data selection & JavaScript
      • ⚡Event handlers
      • 🔎JavaScript Query
      • ✖️Dynamic variable
      • 💱Transformers
      • 🧮Data responder
      • ↕️Built-in JS functions
      • 📚Third-party libraries
    • 🖌️Styling
      • 📝Themes
      • 🖍️Customize styles
  • 🚀Database & API
    • 🔎Queries
    • 🧰Query repository
    • 📡Datasources
      • 🌎API
        • 1️REST API
        • 2️GraphQL
        • 3️Google Sheets
      • 🟠SQL Databases
        • 1️Oracle
        • 2️Microsoft SQL Server
        • 3️MySQL
        • 4️PostgreSQL
        • 5️MariaDB
      • 🟡NoSQL Databases
        • 1️MongoDB
        • 2️CouchDB
        • 3️DynamoDB
      • 🔴REDIS
      • 🟢BigData & OLAP
        • 1️Big Query
        • 2️Snowflake
        • 3️ClickHouse
        • 4️Elasticsearch
      • 🌐WebSocket
  • 💻Integrations
    • 1️ANGULAR
    • 2️HTML Pages
Powered by GitBook
On this page
  • Create a new query
  • Input parameters
  • Version management
  • Publish
  • History version
  • Import a query
  • Permissions
  1. Database & API

Query repository

PreviousQueriesNextDatasources

Last updated 1 year ago

The Query Repository functions as a platform for storing, reusing, and sharing data queries sourced across your workspace. Queries are created and executed in the query repository, and can then be accessed from any QuickDEV app.

Create a new query

  1. Click + New and select a data source.

  2. Rename the query on demand.

  1. Click the ▶ execute button to run the code and view the results. The results will be displayed in the window's bottom panel.

Input parameters

QuickDEV supports passing dynamic parameters to a query by introducing input configuration for the query.

To add input parameters, click on "Add" in the Inputs tab located in the right pane. You can reference these parameters using {{ }} in the query. This allows you to input test values to evaluate the execution of the query.

To edit the name and description of the input variables, click on the ellipsis (...) and choose "Edit", or simply click on the title of the variable directly.

Version management

Queries can be updated as needed, allowing you to make adjustments to a newer version while retaining the older version. This version management feature is available in the query repository. Click on the ··· in the top right corner to publish different versions of queries. You can also view and restore previous versions from the history.

Publish

History version

To view and restore the history versions, go to ··· > History version.

You can restore your current draft to a history version by selecting the target version from the history version list and clicking Restore this version.

Import a query

  1. In an app or module, Click + New in the Query editor in the bottom pane, then select Import from Query Repository.

  1. Select a query from the repository from the dropdown list, choose your desired version and pass in corresponding input parameters.

Permissions

Workspace Admin and members of Developers group have access to the Query Repository and have read and write permissions to all queries in the library.

You can post the query once you've finished writing it. Press ··· >. Release. When naming your version, use semantic

🚀
🧰
semantic versioning
Publish query
Name your version using semantic versioning