Hi Team,

I have created one data list and make a filter condition e.g. 

(e.customProperties.sales_manager='#currentUser.username#' Or e.customProperties.sales_person='#currentUser.username#' Or e.customProperties.csr_name='#currentUser.username#')

It is working fine, but I need to add one more filter condition in the data list by Group. I created one group (JDSCC) in this group now 3 to 4 people but I want to add the group-wise filter means. Once the user login and filters condition check if a user is available in the group data display not display.

Action Taken:

Added hash variable in the filter #users.group.GROUP_ID.username#

Errors:

unexpected char: ';' [SELECT e.customProperties.job_code, e.customProperties.category, e.customProperties.job_name, e.customProperties.sales_order_no, e.customProperties.po_number, e.customProperties.po_date, e.customProperties.client_name, e.customProperties.csr_name, e.customProperties.sales_manager, e.customProperties.sales_person, e.customProperties.actual_status, e.id FROM app_fd_jobdocket e WHERE (e.customProperties.already_created = ?) AND lower(e.customProperties.already_created) like lower(?) AND (e.customProperties.sales_manager='admin' Or e.customProperties.sales_person='admin' Or e.customProperties.csr_name='admin') In (admin;cat) ORDER BY cast(e.dateModified as string) DESC]**