dot-walking from task_sla to incident table custom field

[Antonio24]

Hi to everyone...just a little doubt about SLA, workflow and dot-walking: I have a SLA with his workflow with notification at 50% and 75%, for the notification at 100% I have a "If" condition which "yes" brings to a notification and "n"o brings to another one. My "If" condition is setted to the value in a custom field on incident table, so the dot-walking I used is like:

task.ref_incident.u_field (where u_field is my custom field)...

workflow seems work with this dot-walking but the question is: how I've reached my custom field in incident from task table (actually from task_sla)? is the dot-walking correct?

[asifnoor]

Hi Antonio,

It is correct. If the current table contains a reference to another table, any field on the referenced table can be accessed using dot-walking.

The recommended limit for chain length is three levels. Because more the dot walking, more the joins internally and will create performance issues.

Mark the comment as a correct answer and also helpful if it answers your question.