Query Builder List Guide
The Query Builder module allows administrators to create, manage, and maintain reusable SQL query definitions throughout the OJOO Business OS Platform. Query Builders are used for List Views, Dashboards, Reports, APIs, Workflows, Analytics, and Dynamic Components.
Overview
Query Builders provide a centralized mechanism for retrieving and processing business data.
- Create reusable SQL queries
- Support reporting and analytics
- Feed dashboards and charts
- Power workflows and automations
- Generate API data sources
- Drive List View and Form View configurations
Query Builder List Table
Displays all configured query builders available within the platform.
| Column | Description |
|---|---|
| Actions | View and delete query builders. |
| Query ID | Unique identifier assigned to each query. |
| Query Slug | System-friendly query identifier. |
| Query Name | Display name of the query. |
| Query Store Variable | Variable used to store query results. |
| Query Date | Date and time of query creation. |
Action Buttons
| Action | Description |
|---|---|
| View | Open query builder details. |
| Delete | Remove query configuration. |
Top Toolbar Options
+ Create
Create a new query builder.
API's
Access API documentation.
Help Guide
Access user training materials.
Export & Utility Options
- Copy query records
- Export to Excel
- Export to CSV
- Export to PDF
- Print query list
- Column visibility management
- Restore default columns
Search & Pagination
- Instant query search
- Records per page selection
- Pagination controls
- Quick navigation through large datasets
Common Query Types
Applications List
Retrieve application records.
Modules List
Retrieve module records.
Workflow Queries
Workflow automation data retrieval.
Analytics Queries
Dashboard and reporting data.
Best Practices
- Use meaningful query names.
- Keep SQL optimized.
- Avoid unnecessary joins.
- Use reusable query structures.
- Document query purpose clearly.
- Review unused queries regularly.