SQL snippets - aavedula/how-to-notes GitHub Wiki

Back

This one allows you to match any element in an array.

    sql_query = <<-EOQ
SELECT loas.start_event_id
FROM hrcp_ed_visits, loas, hospital_referred_care_periods
WHERE hrcp_ed_visits.primary_source_type = '#{Loa.name}'
AND hrcp_ed_visits.primary_source_id = loas.id
AND hrcp_ed_visits.hospital_referred_care_period_id = hospital_referred_care_periods.id
AND hospital_referred_care_periods.hospital_id = '#{hospital.id}'
AND loas.start_at > '#{interval.first}'
AND loas.start_at <= '#{interval.last}'
AND loas.start_event_id <> ANY('{#{event_ids}}'::int[])
    EOQ
    
    HrcpEdVisit.loa.find_by_sql(sql_query)