updated both approved and unapproved methods to correctly select data