Vacancies text search filter added to specifications plus all SQL generating logics moved to specifications