show all rows from xxxx [xxx == zoho.loginuserid] has stopped fetching results in a view

show all rows from xxxx [xxx == zoho.loginuserid] has stopped fetching results in a view

Hi
 
we use 'show  all  rows  from  Submit_IP_Topic [IP_Approver == zoho.loginuserid]' to show only items that belong to the IP approver specified in that field. it used to return results and has failed again and will not display anything.
 
am i doing something wrong here? i have learnt that i need to use 'advanced' when you wish to use zoho.loginuserid otherwise it is treated as a value.
 
often if i clear out the filter then reapply it to the view it will start returning values again.
 
cheers
Lathan