def users(page): search_form = SearchForm() bulk_form = BulkDeleteForm() sort_by = User.sort_by(request.args.get('sort', 'name'), request.args.get('direction', 'asc')) order_values = '{0} {1}'.format(sort_by[0], sort_by[1]) paginated_users = User.query \ .filter(User.search(request.args.get('q', ''))) \ .order_by(User.role.desc(), User.payment_id, text(order_values)) \ .paginate(page, 20, True) return render_template('admin/user/index.jinja2', form=search_form, bulk_form=bulk_form, users=paginated_users)