Row Level Permission

I am trying to implement row level permissions. Introduction of where clause empties my dataset and no data is returned.

SELECT * FROM dcf_vw_NRM_Internal_Sales
–where clause that empties the dataset below
where query_user() in (‘’) and category in (‘Spirit’)

Hi @akiladevi.b

Is this failing due to the query_user or category filter?