Appizap
  • Appizap Overview
  • Build Apps
    • On-boarding Flow
    • Ideas to Apps using AI
    • Create a new app
    • App Configuration
      • App Overview
      • General Settings
      • Domain Settings
      • Version Release & Management
      • App Assets
      • Auth Settings
    • UI Builder
      • Module
      • Menu Navigation
      • Version Logs & Restore
      • Keyboard Shortcuts
    • GUI, Themes & Styles
    • Event handlers
    • Write JavaScript
      • JavaScript within {{ }}
      • JavaScript Query
      • Transformers
      • Temporary State
      • Data Responder
      • Built-in JavaScript Functions
      • Use Third-party Libraries
    • How-to-use
      • Welcome to Appizap!
      • FAQ
  • Appizap Dashboard
    • Your Apps
    • Database
    • Workflows
    • Media & Files
    • Query Library
    • Audit Logger
    • Templates
  • Workspaces
    • Workspace Settings
    • User Authentication
    • User Groups
    • Themes
    • Advanced
  • Appizap Concepts
  • Appizap Studio
    • Data Browser
      • Screen, Modules & Navigations
      • Active Components
      • In-App Modals
      • Data Queries in your App
      • Global Data Variables
    • Layers
    • Screen Settings
    • Debugger
    • Data Queries
    • Widget Library
      • Link
      • Icons
      • Steps
      • Button Group
      • Form Button
      • Grid
      • Responsive Grid Layout
      • Drawer
      • Navigation
      • Cascader
      • Comment
      • Mention
      • Collapsible Container
      • Rich Text Editor
      • Input
      • Modal
      • Text Display
      • Number Input
      • Password
      • List View
      • Date
      • Checkbox
      • Radio
      • Switch
      • Multi Select
      • Dropdown
      • File Upload
      • Phone Number Input
      • Download Pdf Button
      • Image
      • Divider
      • Progress Circle
      • Progress
      • Form
      • JSON Schema Form
      • Container
      • Tabbed Container
      • Table
      • Date Range
      • Time
      • Time Range
      • Toggle Button
      • Segmented Control
      • Rating
      • Timeline
      • Slider
      • Range Slider
      • Control Button
      • File Viewer
      • Image Carousel
      • Lottie Animation
      • Tree
      • Tree Select
      • IFrame
      • Calendar
      • Custom Component
      • Auto Complete
      • Chart
      • Graph Chart
      • Treemap Chart
      • Basic Chart
      • Geo Map Charts
      • Funnel Chart
      • Candlestick Chart
      • Select
      • Audio
      • Caller
      • Text Area
      • Responsive Flex Layout
      • Timer
      • Image Editor
      • AI Component
    • Component Specific Actions
  • Database
    • Connect DB
    • Build Internal DB
      • Arrays
      • Indexes
      • Using JSON Type
      • Cascade Delete
      • Data Load and Import
    • Data Sources
      • Connect Data Sources
        • Big Query
        • ClickHouse
        • CouchDB
        • DynamoDB
        • Elasticsearch
        • MariaDB
        • Microsoft SQL Server
        • MongoDB
        • MySQL
        • Oracle
        • PostgreSQL
        • Redis
        • Snowflake
      • Connect APIs
        • REST API
        • GraphQL
        • Google Sheets
        • S3
        • OpenAPI
        • Firebase
        • WooCommerce
        • OpenAI
        • Athena
        • Lambda
    • Query Library
    • Storage
      • Buckets
      • Uploads
      • Objects
  • Appizap Workflow Builder [Pro]
    • Workflows
      • Create a workflow
      • Nodes
      • Connections
      • Sticky Notes
      • Tags
      • Import and Export
      • Templates
      • Sharing
      • Settings
      • History
      • Find Workflow ID
    • Build Flow Logic
      • Conditional Nodes
      • Data Merging
      • Looping
      • Waiting
      • Sub-Workflow
      • Execution Order
    • Data Handling
      • Data Structure
      • Transforming data
      • Use Code
      • Mapping using UI
      • Data Item Linking
      • Data Pinning
      • Data Editing
      • Data Filtering
      • Data Mocking
      • Binary Data
    • Editor UI
    • Credentials
      • Create and Edit
      • Sharing
    • Integrations
      • Node Types
      • Core Nodes
      • Actions
      • Triggers
      • Credentials
      • Custom API Operations
    • Error Handling
      • Errors related to memory
    • Keyboard Shortcuts
  • Security & Compliance
  • Terms & Conditions
  • Privacy Policy
  • User Guide
    • Getting Started
    • Admin Console
    • Data Maintenance
Powered by GitBook
On this page
  • Code
  • DbBuilder
  • Notification tab and Advanced tab
  • Temporary State
  • Transformer
  • Data Responder
  • Run JavaScript Code
  • Logout User (Auth)
  • Import from Query Library
  • Folder
  • Your Data Sources
  1. Appizap Studio

Data Queries

PreviousDebuggerNextWidget Library

Last updated 4 months ago

Queries support you to read data from or write data to your data sources. You can create queries while editing an app or in the query library. This tutorial walks you through how to create a query and tailor it to your needs.

Code

DbBuilder

The UI of query editor varies when you choose different types of data sources. Below is an example of a connection to a DbBuilder and a corresponding statement.

Choose Data Source

Select the datasource from the list - or - create a new datasource and attach.

Trigger when

Appizap triggers your queries in two modes, either run automatically when inputs change or on page load, or manually invoked in event handlers.

Trigger when - Inputs change or on page load

Queries set to this mode automatically run when dependent inputs change or on page load. For example, the query result of select * from users where customer_id = {{input.value}} updates immediately when input.value changes. **** This mode to run a query is recommended for queries reading data from data sources.

Trigger when - Manually invoked

For this mode of queries, they run only with your manual trigger, such as a button or link click. You need to specify an event handler to trigger the query. This mode is recommended for queries writing data to data sources, because you may need to confirm that the input is complete and error-free before running it.

How to choose a query's trigger mode?

In most cases, queries reading data, like select operations, can be set to the former mode, and those writing data, like create/delete/update operations, run the latter way.

When Appizap detects your query statement switches from reading to writing data, the trigger mode switches to Manually invoked automatically, but not the other way around.

Table

The display provides a comprehensive view of all the tables accessible within the DbBuilder source. Users have the option to select a specific table from the displayed list of tables.

Actions

Property
Description

Create row

To insert a new record into the table picked. User needs to enter the values for each column of the table.

Update row

To update an existing row of the table. The user needs to provide the id value and values for the other columns of the table.

Delete row

To delete one or more rows from the selected table, the user can set the criteria using the input fields shown below this field and the records matching the criteria get deleted.

List

To retrieve the existing records from the table, the user can set the criteria using the input fields shown below this field and the records matching the requirements get pulled. The "Limit" field permits the user to input a numerical value, and the query will fetch that specific number of records.

Custom Query

Appizap evaluates your query statement with JavaScript code inside {{ }} in real-time, and the result is displayed below in a floating box, so you can use it to check the correctness of the query statement.

Event Handlers

The user can activate an action following the execution of the query event. There are two possible outcomes: 'success' and 'failure', with the action being triggered accordingly.

Notification tab and Advanced tab

In notification and advanced tabs, you can configure settings regarding notifications, timeout, periodic run, and more. Settings in Notification tab and Advanced vary based on trigger mode of your query.

Tab
Settings
Inputs change or on page load
Manually invoked

Notification

Display a Success message after running

🚫

✅

Display a Failure message after running

✅

✅

Advanced

Display a confirmation modal before running

🚫

✅

Set timeout for query running

✅

✅

Perform query periodically

✅

🚫

Temporary State

Transformer

Data Responder

Run JavaScript Code

Allows the users to engage in writing and manipulating javascript code, providing a platform for the creation and modification of scripts that can be executed.

Logout User (Auth)

When the user calls and executes this query, the logout action is triggered.

If a new execution is triggered, the result of the previous uncompleted executions will be ignored if the previous executions did not complete, and the ignored executions will not trigger the event list of the query.

Import from Query Library

Pick the required query from the library, that is created using Query Library interface. It can be viewed in a separate window for quick reference. It allows the user to choose the version of the query from its history.

The user can activate an action following the execution of the query event. There are two possible outcomes: 'success' and 'failure', with the action being triggered accordingly.

Folder

A new directory is generated within the Data Queries segment. The folder will contain all relevant files for ease of access. The newly created folder is meant to store various files and documents within the Data Queries area for convenient retrieval.

Your Data Sources

Refer to for more details.

Refer to for more details.

Refer to for more details.

Refer to for more details.

Refer to for more information.

Temporary State
Transformer
Data Responder
Write JavaScript
Data Sources