lfucg/lexington-pentaho-etl

Make sure the queries for the most recent data is correct

Opened this issue · 0 comments

For code enforcement:

SELECT * from vw_OpenData_CodeEnf_Cases 
WHERE Cast(StatusDate as datetime) >= dateadd(day,-1,getdate())
ORDER BY Cast(StatusDate as datetime) DESC;

and building permits:

SELECT * 
FROM vw_OpenData_BI_Permits 
WHERE Date >= dateadd(day,-1,getdate());