Using Zoho Criteria to pass a parameter to a report URL

Using Zoho Criteria to pass a parameter to a report URL

Hello

Can anyone help me? I'm tearing my hair out trying to determine whether my issue is syntax-related or that I'm trying to do something that just cannot be done.

As part of my report url, I have the following Zoho Criteria specified...

...ZOHO_CRITERIA=(%22Work Completed%22.%22Email%22%3DCurrentUser)&ZOHO_DELIMITER=0">

where:

'Work Completed' is the name of the Zoho Reports table in the Report that I am referencing to embed into my Zoho Creator Page. (I must specify the table as the same field name appears in more than one table.)

'Email' is the field in this table/zoho report that I want to match to the CurrentUser. CurrentUser is a variable set to 'zoho.loginuserid'. So my Zoho criteria is to only show records where the Email field matches the current user's zoho.loginuserid.

I either get error messages relating to the 'Work Completed' part of the syntax or I get an empty report with headers.

Any help would be appreciated.

Regards

Stuart