Use the date filter

Get Help
1

Hi
I wrote a query and I am using a date filter for a time range. When the start and end date are the same, the result is not displayed, and I want to be able to see results for a single day in some cases.

SELECT
 format(cast("dbo"."UserTickets"."CreatedAt" as date),'yyyy/MM/dd','fa') as 'date',
  "Transactions - TransactionId"."PaymentGateway" AS "Transactions - TransactionId__PaymentGateway",
  count(*) AS "count"
FROM
  "dbo"."UserTickets"
 
LEFT JOIN "dbo"."Transactions" "Transactions - TransactionId" ON "dbo"."UserTickets"."TransactionId" = "Transactions - TransactionId"."Id"
WHERE
    (
      "dbo"."UserTickets"."EffectivePrice" <> 0     
    OR "dbo"."UserTickets"."EffectivePrice" IS NULL
    )   
   AND "Transactions - TransactionId"."PaymentStatus" = 2
  

     [[AND "dbo"."UserTickets"."CreatedAt" >= {{StartDate}}]]
     [[AND "dbo"."UserTickets"."CreatedAt" <= {{endDate}} ]]


 
GROUP BY
  cast("dbo"."UserTickets"."CreatedAt" as date),
  "Transactions - TransactionId"."PaymentGateway"
ORDER BY
   date desc,
  "Transactions - TransactionId"."PaymentGateway" asc```

Please guide me on how to add this condition.
Thanks
2

How are your filters set up? It can be helpful to click the "eyeball" icon on right side of the query editor after you apply values to your filters. This lets you see exactly what SQL is generated:

date
date1567×706 53.2 KB