refactor get query for attendee list
reformat cdoe