Contents

Cancel

Recommended Articles

  1. unify-apps

    Indexing

    Unify AI

    Transform raw content into searchable knowledge through AI-powered indexing and vector embeddings

  2. unify-apps

    Quentn

    Unify Integrations

    Integrate your app with Quentn to automate marketing campaigns, manage contacts, and optimize customer engagement.

  3. unify-apps

    JobNimbus

    Unify Integrations

    Integrate your application with JobNimbus to manage leads, track jobs, and streamline your workflow processes efficiently

  4. unify-apps

    IMAP

    Unify Integrations

    Integrate your app with IMAP to enable seamless email synchronization, real-time access, and enhanced communication workflows.

  5. unify-apps

    Preview Your Work

    Unify Automations

    Effortlessly review & monitor your automation’s performance

  6. unify-apps

    QuickBooks

    Unify Integrations

    Integrate your app with QuickBooks to streamline accounting, automate invoicing, and manage finances effortlessly

  7. unify-apps

    FTP/FTPS

    Unify Integrations

    Connect your app with FTP/FTPS to automate secure file transfers and streamline data exchange across systems.

  8. unify-apps

    Filters

    Unify Applications

    Enable users to refine, search, and sort data effortlessly across dashboards and datasets

  9. unify-apps

    Insided

    Unify Integrations

    Integrate your app with Insided to enhance customer engagement, streamline community management, and drive self-service support.

  10. unify-apps

    Reverse Polling

    Unify Data

    Reverse Polling technique efficiently retrieves recent data from APIs that return results in chronological order (oldest first), optimizing pagination and data processing strategies when working with time-ordered data sources.

  11. unify-apps

    Facebook Ads

    Unify Integrations

    Connect your app with Facebook Ads to automate campaign management, optimize ad performance, and track marketing success.

  12. unify-apps

    Gainsight

    Unify Integrations

    Integrate your app with Gainsight to enhance customer success, automate engagement workflows, and drive retention

  13. unify-apps

    Livestorm

    Unify Integrations

    Integrate your app with Livestorm to streamline webinar hosting, automate event management, and enhance audience engagement.

  14. unify-apps

    Snowflake

    Unify Automations

    Connect to Snowflake for fast, scalable cloud data warehousing and analytics

  15. unify-apps

    Pipeline CRM

    Unify Integrations

    Integrate your app with Pipeline CRM to streamline sales processes, automate lead management, and enhance customer relationships

  16. unify-apps

    Cognito Forms

    Unify Integrations

    Integrate your app with Cognito Forms to create custom forms, automate data collection, and streamline workflows

  17. unify-apps

    Button

    Unify Applications

    Create interactive elements with ease using buttons

  18. unify-apps

    Baserow

    Unify Integrations

    Integrate your app with Baserow to create collaborative databases, automate data workflows, and streamline project management

  19. unify-apps

    BambooHR

    Unify Automations

    Integrate your app with BambooHR to streamline HR management, automate employee data processing, and enhance onboarding workflows

  20. unify-apps

    Polling Techniques

    Unify Data

    Essential strategies for efficiently extracting data from source systems with optimal performance and reliability

Unify Applications
Logo
Add Data Sources
Logo
Data Source Settings

Data Source Settings

Logo

3 mins READ

Overview

Query execution behavior can be configured in both web and mobile apps, allowing queries to run automatically or manually based on your preferences. Additionally, there are options to customize this behavior further depending on whether the query is retrieving data or making modifications. By understanding and adjusting these settings, you can optimize query performance and enhance overall app efficiency, ensuring smoother data management and better control over app functionality.

Run Behavior Options

Run Behaviour

Description

Automatic 

Queries set to run automatically execute as soon as their associated block becomes visible on the user interface (UI)

Manual

Queries set to run manually only execute when they are explicitly triggered by a user action, such as clicking a button

Running a Query Automatically

Running a query automatically means the query executes on its own without user input, typically triggered by certain conditions, such as loading a page or when specific data changes. This ensures real-time data updates and a seamless user experience without manual intervention

Go to Run Behaviour in input tab > Select Automatic 

Image
Image

Running a Query Manually

For queries that read large datasets, it is recommended to configure them for manual execution. Frequent automatic execution of such queries can lead to performance issues or cause rate limits with external data sources.

Go to Run Behaviour in input tab > Select Manual

Image
Image

Additional Run Behavior Options

In addition to running queries automatically or manually, you can configure additional options in the Advanced tab. Available options depend on the query's run behavior.

Running a query on page load

  • By default, automatic queries execute when the app page first loads, ensuring that the user sees the most recent data immediately.

  • You can also enable this behavior for manual queries by navigating to the Advanced tab and selecting the option Run this query on page load. This will allow the query to run automatically when the app loads, even if it is typically triggered manually.

    Image
    Image

Running a query periodically

  • You can set queries to run at regular intervals, which can be useful for keeping data updated without user input. For example, if your app relies on real-time data, periodic query execution ensures that users always see the most current information.

  • To enable this, go to the Advanced tab and check the option Run this query periodically. You’ll then need to specify the interval at which the query will re-execute, in milliseconds. For example, setting the interval to 10000 will cause the query to run every 10 seconds.

    Image
    Image

Refreshing a query on window focus

You can configure queries to refresh whenever the app window regains focus, ensuring that users see the latest data each time they return to the app. 

Image
Image

Preventing queries from running

  • In more complex applications, where multiple queries are involved, it may be necessary to prevent certain queries from running until specific conditions are met. You can prevent a query from executing by adding conditions where you can map the difference. 

  • If a condition is set where the Count of total users is less than 10, the query will fail to execute.

    Image
    Image

  • You can configure a Disabled error message to be displayed when a query fails due to the Disabled condition being set.

    Image
    Image