Call Transfer using CTI RP to another queue. Trying to find the CallDispositionFlag

[Lee Walsh]

I am querying the t_Termination_Call_Detail with the following query but I am trying to place a date range search, and conditions on the DigitsDialed (='14334'), Variable1 (XFR_Tier1).

how do i modfiy this query so that I can have this daterange search and conditions on DigitsDialed and Variable1?

SELECT [PeripheralID]
,[DateTime]
,[DigitsDialed]
,[CallDisposition]
,[Duration]
,[RingTime]
,[Variable1]
,[DNIS]
,[ANI]
,[CallDispositionFlag]
FROM [cc123_hds].[dbo].[t_Termination_Call_Detail]

[Omar Deen]

SELECT PeripheralID, DateTime, DigitsDialed, CallDisposition, Duration, RingTime, Variable1, DNIS, ANI, CallDispositionFlag
FROM t_Termination_Call_Detail
WHERE DateTime >= '2020-03-30 00:00:00' AND DateTime < '2020-04-07 00:00:00'
AND Variable1 = 'XFR_Tier1'
AND DigitsDialed = '14334'
ORDER BY DateTime DESC