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…

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

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) 22.Август.2023 13:06:23 2

СТРОКА 16: WHERE p.created_at::date BETWEEN :start_date AND :end_date -…

Тема		Ответов	Просм.
Category name params support Data & reporting sql-query	1	138	04.07.2025
Dashboard Report - Posts Data & reporting sql-query , dashboard-reports , dashboard-sql	3	755	09.09.2025
Dynamic params to use with Data Explorer Data & reporting sql-query	4	317	06.02.2025
Using Parameters in Data Explorer Queries Data & reporting data-explorer , sql-tutorial	6	2048	10.02.2026
Run a query based on a timeframe Data & reporting sql-query	2	363	21.06.2023

Добавление параметра даты

Связанные темы