Custom Queries

Library -> Custom Queries

The Custom Query feature in Appverse offers advanced capabilities for data retrieval. It can be used in various contexts such as to create dynamic and interactive user experiences, enhance dashboards, and trigger conditional email or SMS notifications.

Dynamic Lists in Forms

Custom Queries can be used to create query-based dynamic lists in forms.

• Example: A form for order entry could dynamically fetch a list of available products and price lists by combining data from these two different data sources using a query.

Analytics Views for Dashboards

Custom Queries can play a crucial role in analytics views for dashboards. They allow users to create custom views that pull together specific data points for analysis, combining multiple sources and applying custom filters to generate meaningful insights.

• Example: A custom query could aggregate sales data from different regions, apply date range filters, and display results in a dashboard for detailed performance analysis across multiple teams or time periods.

Conditional Notifications

Custom Queries can also be used to trigger conditional notifications based on specific data conditions. By defining custom queries with business rules, Appverse can automatically send notifications when certain conditions are met.

• Example: If inventory levels fall below a predefined threshold, a custom query could trigger an automatic email or push notification to the relevant team or user, ensuring timely actions are taken to address the issue.

How Custom Queries work in Appverse

To use custom queries in Appverse

1. Create Custom Queries – Create queries that retrieve or filter data based on your specific business logic.

2. Integrate with Forms, Dashboards, or Notifications – Use these queries to populate dynamic lists in forms, use in analyitcs live dataset, or set up automated triggers for notifications.

The Custom Query feature is an advanced option available exclusively to Enterprise Subscription users. With Custom Queries, you can configure complex forms and create highly customized dashboards, allowing you to tailor the app's functionality to your organization's unique requirements.

This feature is ideal for businesses that have highly customized requirements or analytics needs.

Please note

Custom Queries are available only with an Enterprise Subscription. For more information on how to access and set up Custom Queries, please contact us.