Boards
About 361 wordsAbout 1 min
2026-03-28 16:20:00
Build classroom dashboards with SQL
Boards support multiple dashboards, multiple lists, and split layouts. You can write SQL and present results as cards, grids, or tables.
Entry and Permission
- Entry: sidebar
Boards - Permission:
View / Points / Admincan open and view board data- Only
Admincan edit board configs (add/remove/rename, SQL, layout)
Board Structure
A board has three layers:
- Board: scenario container (for example, "Live Class", "Weekly Review")
- List: each list runs one SQL query
- Layout: split left/right or top/bottom, then drag divider to resize
At least one list is always kept in each board.
SQL Rules
Current execution rules:
- Only one read-only
SELECT/WITHquery is allowed ;, comments (--//* */), and write-like keywords are blocked- Result rows are capped at 500 per run (UI requests 500)
Time Template Variables
These placeholders are replaced with ISO timestamps at runtime:
{{today_start}}{{this_week_start}}{{last_week_start}}{{since_7d}}{{since_30d}}{{now}}
Rendering and Field Mapping
Student Card Detection
If result rows contain a student name field, the board renders student cards:
- Supported name keys:
student_name/name/studentName
If no name key is found, results are shown as a generic table.
Common Metric Keys
Boards try to detect and render these metrics:
- Total score:
score - Added score:
add_score/addScore/plus_score/plusScore - Deducted score:
deduct_score/deductScore/minus_score/minusScore - Reward points:
reward_points/rewardPoints - 7-day change:
week_change/range_change/change - 7-day deductions:
week_deducted/deducted - Today's answers:
answered_count/answer_count
View mode supports List / Card / Grid. Score display supports Total or Add + Deduct.
Built-in Presets
Three SQL presets are built in:
- Low Deduction (7d): rank students with low deductions in the last 7 days
- Today's Activity: sort by today's answer count and score change
- Reward Ranking: sort by reward points and total score
Refresh Behavior
- Switching board or editing SQL triggers query rerun
- Board auto-refreshes when students/events/reasons data changes
- You can also click
Refreshin the top-right area to reload configs
Related Modules
- Daily operations: Scoring
- Time-range ranking export: Leaderboard
- Stage archive: Settlement
Contributors
Changelog
3/29/26, 7:58 AM
View All Changelog
388c1-feat(docs): 更新导航和新增功能文档on
Copyright
Copyright Ownership:SECTL
License under:CC BY-NC-SA 4.0