gistfile1.txt

SCHEDULER.every '10m', :first_in => 0 do |job|
require 'sequel'

db  = Sequel.connect('tinytds://user:pass@server')

openticketsbymember = db["SELECT dbo.Member.First_Name + ' ' + dbo.Member.Last_Name as Name, COUNT(DISTINCT dbo.Schedule.RecID) AS Qnt FROM dbo.Member INNER JOIN dbo.SR_Status INNER JOIN dbo.Schedule INNER JOIN dbo.SR_Service ON dbo.Schedule.RecID = dbo.SR_Service.SR_Service_RecID ON dbo.SR_Status.SR_Status_RecID = dbo.SR_Service.SR_Status_RecID ON dbo.Member.Member_RecID = dbo.Schedule.Xref_Mbr_RecID WHERE(dbo.SR_Status.Closed_Flag = 0) and (dbo.Schedule.Close_Flag=0) and (dbo.SR_Status.Description NOT IN ('Completed')) GROUP BY dbo.Member.Last_Name, dbo.Member.First_Name, dbo.Member.Member_RecID"].all

array = openticketsbymember.map(&:values).flatten

tickets_formatted = array.each_slice(2).map{|s| s.join(' - ') }.join('<br/>')


  send_event('open_tickets_by_member', {text: tickets_formatted })
end