Error MessageInvalid 'Access Control' record even though the selected outside table 'Case' is allowed

[Mahesh44]

Hello Everyone,

I am getting this error "Invalid 'Access Control' record even though the selected outside table 'Case' is allowed. A table level Access Control on an outside table cannot contain a condition or script. Only roles are allowed"

Below is the script. Can anyone help with this?

 var Contact = gs.getUserID();

 var grVenCon = new GlideRecord('customer_contact');
 grVenCon.addQuery('sys_id', Contact);
 grVenCon.query();
 grVenCon.next();

 var venId = grVenCon.account;

 var grVenProd = new GlideRecord('u_cmdb_model_solution_provider_product');
 grVenProd.addQuery('u_solution_provider_id', grVenCon.account);
 grVenProd.query();


 var grCases = new GlideRecord('sn_customerservice_case');
 grCases.addQuery('u_customer_facing_flag', true);
 grCases.addQuery('u_asset.u_solution_provider_product.u_solution_provider_id', grVenCon.account);
 grCases.query();

 while (grCases.next()) {
 	answer = true;
 }

[Ankur Bawiskar]

Can you share screenshot of the error?

ACL is on which table? you are in which scope?

[Mahesh44]

Hello Ankur,

Below is the screenshot, the table is custom one. I am in the global application.

Thanks,

Mahesh

[Mahesh44]

Hello @Ankur Bawiskar @Aman Kumar 

I updated in "Curstomer service" application ACL updated without any error but still I am not able to see the records in the portal who has the role I have given.

Thanks,

Mahesh

[Ankur Bawiskar]

Hi,

Any query business rule is restricting the records?

Regards
Ankur

[Mahesh44]

Hi,

There is no query business rule on this table

Regards,

Mahesh