attendance query updates