I have a view that shows 16 records in it, 1 added by another user and 15 added by me.
I have a view that limits what is shown by zoho.loginuser criteria, this is done in the view definition.
If I embed the view in an HTML file and look at it locally the widget shows the correct number of rows depending on who is logged in, however if I retrieve data using an API call (to export the data). It always returns my data (15 rows) no matter who is logged in.
If I use the export function of the view rather than my own JS API call the data is as you would expect? ie 1 row in one export and 15 in the other.
An alternative is to pass the logged in user via the API criteria parameter and remove it from the view defintion, this seems to work if I hard code the user but does not seem to like zoho.loginuser so that it is dynamic.
Thanks for any help
Gordon