Often you will want to pull out data for a specific time period. You can do this by hard-coding in your time period into the query itself, but to make your report more future-proof you can add a date parameter: This query is designed to count the total number of posts in each category (excluding d…

Ah yes, it doesn’t like those inline comments next the parameters. -- [params] -- date :start_date -- date :end_date SELECT t.category_id, COUNT(p.id) AS "Total Posts" -- Count the number of posts in each category FROM posts p JOIN topics t ON t.id = p.topic_id WHERE p.created_at::date…

添加日期参数

社区数据与报告

Jagster (Jakke Flemming) 2023 年8 月 22 日 13:06 2

PG::SyntaxError: ERROR:  syntax error at or near \":\"
LINE 16: WHERE p.created_at::date BETWEEN :start_date AND :end_date -…

话题		回复	浏览量
Category name params support Data & reporting sql-query	1	138	2025 年7 月 4 日
Dashboard Report - Posts Data & reporting sql-query , dashboard-reports , dashboard-sql	3	755	2025 年9 月 9 日
Dynamic params to use with Data Explorer Data & reporting sql-query	4	317	2025 年2 月 6 日
Using Parameters in Data Explorer Queries Data & reporting data-explorer , sql-tutorial	6	2049	2026 年2 月 10 日
Run a query based on a timeframe Data & reporting sql-query	2	363	2023 年6 月 21 日

添加日期参数

相关话题