/** Returns an ArrayList of tickets by queue */ public static ArrayList<Ticket> getTicketsByQueue(String queueName) { DBHelper db = DBHelperFactory.createDBHelper(); int queueType = 0; String requestedQueue = queueName.toLowerCase(); if (requestedQueue.equals("pending")) { queueType = 0; } if (requestedQueue.equals("active")) { queueType = 1; } if (requestedQueue.equals("closed")) { queueType = 2; } ArrayList<Ticket> result = db.createTicketArrayListByQueue(queueType); db.close(); return result; }