public static ArrayList<FullTicket> showAll(String status) {
            ArrayList<FullTicket> fulltickets = new ArrayList<FullTicket>();
            StringBuilder query = new StringBuilder();
            Database db = dbconnect();
	try {
                query.append ("SELECT * FROM full_ticket ");
                if ("Open".equals(status)) {
                query.append("WHERE ticket_status = 'Open'");
                db.prepare(query.toString());
                } else if ("In process".equals(status)) {
                query.append("WHERE ticket_status = 'In process'");
                db.prepare(query.toString());
                } else if ("Closed".equals(status)) {
                query.append("WHERE ticket_status = 'Closed'");
                db.prepare(query.toString());
                } else {
                query.append("ORDER BY TID");
		db.prepare(query.toString());
                }
		ResultSet rs = db.executeQuery();         
		while(rs.next()) {
                   fulltickets.add(FullTicketObject(rs));
		}
	           db.close();      

        } catch (SQLException e) {
            Error_Frame.Error(e.toString());
        } 
                return fulltickets;
	}