Tables:
Columns 0
Select a table above to pick columns
WHERE Filters 0

Order & Limit

Exposed Params 0

Wildcards
{{today}} {{current_year}} {{current_month}} {{now}} {{param:name}} {{?param:name}}
Click any chip to copy. {{param:x}} injects a runtime URL param. {{?param:x}} skips the filter if the param is absent.
0 tables
0 cols
0 joins
0 filters
No results yet
Pick tables, columns and click Run
Loading…
Shortcode Embed

Render any saved view by shortcode. Inject runtime parameters via URL query string or the form below.

Test a View
Runtime Params
Usage Reference

API — JSON response:

GET api.php?action=execute_view&shortcode=active_students GET api.php?action=execute_view&shortcode=active_students&status=active

API — HTML table response:

GET api.php?action=render_view&shortcode=active_students GET api.php?action=render_view&shortcode=active_students&year=2025

PHP embed on any page:

<?php require_once 'queryforge/shortcode.php'; echo renderShortcode('active_students'); echo renderShortcode('exams_by_class', ['class_id' => 3]); echo renderShortcode('filtered', $_GET); ?>

CMS-style tag in any text content:

[view:active_students] [view:exams_by_class class_id=3] [view:filtered status="active" year="2025"]