How to make an ACL for a dot walking field?

[snow_beginner]

Hi,

There is a custom table u_learning_data which has a field called task on it.

The 'task' field can take a value of a problem record, problem task record, change record and change task record so it is a reference field to the task table

The issue is that it can take any problem record with any state as its value. So a problem record with state=closed or cancelled can be chosen here, likewise for change too.

The requirement is to make a write, create and delete ACL (read is already there) for the itil user which can do all the things on this table (u_learning_data) but only for those records where the problem state != closed or cancelled AND where the task=problem but not change.

How would I do that? Because in the condition I cannot dot walk from the task.task type or task.state 

Thanks!

[Mark Manders]

Why are you trying to do this through ACL? Why not update the reference qualifier to include states of the task? Only show records from sys_class_name = problem and state != closed/cancelled OR sys_class_name = change_request for any state?

No need to try to do this through ACL's. That would make it very complex, since you don't want them to work through on the tables itself.