vacancy filter queries and update work