import jingrow from pypika import Criterion @jingrow.whitelist() def get_views(pagetype): View = jingrow.qb.PageType("CRM View Settings") query = ( jingrow.qb.from_(View) .select("*") .where(Criterion.any([View.user == "", View.user == jingrow.session.user])) ) if pagetype: query = query.where(View.dt == pagetype) views = query.run(as_dict=True) return views