SInce A2 jobs have no CO, they also don't have any completion dates. We have special logics written up for completion date for Demolition so one way to approach it is to also write some customized logics for it in _mid.sql
(CASE
WHEN a.job_type = 'Demolition'
THEN
CASE
WHEN a.date_statusx IS NOT NULL
THEN a.date_permittd
ELSE NULL END
WHEN a.job_type = 'Alteration (A2)'
THEN a.date_statusx::text
ELSE b._date_complete END) as date_complete,
SInce A2 jobs have no CO, they also don't have any completion dates. We have special logics written up for completion date for Demolition so one way to approach it is to also write some customized logics for it in
_mid.sql