How to remove certain columns in the child table that is extended from parent table

[phr]

Hi All,

I have a requirement to remove some of the columns in the child table B which is extending from the Parent table A

Parent table (A) has "requested for" and the "impacted user" columns that is extended to child table(B).

How to achieve this scenario?

Parent Table A

Child table B

Also as a workaround now we did create a ACL for list view to hide it from the non admin users but still the non admin users are able to see "requested for" field in the filter of the table

Example of ACL created.

How to achieve this .

[Kieran Anson · Accepted solution]

Hi,

You can't remove fields from a child table as they're inherited. A field won't appear in the query builder if they can't read it, so you could add a table_name.field_name read ACL and set it to admin to remove it