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…

Ajout d'un paramètre de date

Communauté Données et rapports

Jagster (Jakke Flemming) Août 22, 2023, 1:06 2

PG::SyntaxError : ERREUR : erreur de syntaxe près de « : »
LIGNE 16 : WHERE p.created_at::date BETWEEN :start_date AND :end_date -…

Sujet		Réponses	Vues
Category name params support Data & reporting sql-query	1	138	Juillet 4, 2025
Dashboard Report - Posts Data & reporting sql-query , dashboard-reports , dashboard-sql	3	755	Septembre 9, 2025
Dynamic params to use with Data Explorer Data & reporting sql-query	4	317	Février 6, 2025
Using Parameters in Data Explorer Queries Data & reporting data-explorer , sql-tutorial	6	2048	Février 10, 2026
Run a query based on a timeframe Data & reporting sql-query	2	363	Juin 21, 2023

Ajout d'un paramètre de date

Sujets connexes