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…

Hinzufügen eines Datumsparameters

Gemeinschaft Daten & Berichterstattung

Jagster (Jakke Flemming) 22. August 2023 um 13:06 2

PG::SyntaxError: FEHLER:  Syntaxfehler in der Nähe von „:“
ZEILE 16: WHERE p.created_at::date BETWEEN :start_date AND :end_date -…

Thema		Antworten	Aufrufe
Category name params support Data & reporting sql-query	1	138	4. Juli 2025
Dashboard Report - Posts Data & reporting sql-query , dashboard-reports , dashboard-sql	3	755	9. September 2025
Dynamic params to use with Data Explorer Data & reporting sql-query	4	317	6. Februar 2025
Using Parameters in Data Explorer Queries Data & reporting data-explorer , sql-tutorial	6	2048	10. Februar 2026
Run a query based on a timeframe Data & reporting sql-query	2	363	21. Juni 2023

Hinzufügen eines Datumsparameters

Verwandte Themen