Dot walked field not showing value

[Drishti]

Hi Community,

I have a requirement where I have to show " Business time left" field from Task SLA on our HR case form.

What I did is : Created a reference field which refers to TASK SLA table. From this field, I have dot walked to "Business time left".
The thing is in Task SLA this field " Business time left" have value but when dot walked on HR case form the field is empty.

Why " Business time left" field when dot-walked on HR case form is not showing any value  although it have value on Task SLA form?
Please guide.

[G Ponsekar]

Hi @Drishti ,

The "Business time left" field on the Task SLA table may not be directly visible or populated on the HR case form due to how dot-walking works with related records and potentially how the SLA definition is configured for HR cases. 

Specifically, the "Business time left" field is calculated based on the SLA's definition and progress, and may not be directly applicable or meaningful in the context of a specific HR case if the SLA is not directly associated with it or if the SLA is not configured to update this field on the related case

Potential Solutions:

• Verify SLA Definition: Review the SLA definition to ensure it's correctly associated with HR cases and that it's configured to update the "Business time left" field on the related case. 
• Create a Business Rule: Consider creating a business rule on the HR case form that triggers when the related Task SLA is updated. This rule can then copy the "Business time left" value from the Task SLA to a field on the HR case form. 

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[Ankur Bawiskar]

@Drishti 

are you checking with admin or non-admin?

it worked for me as admin

Did you fill the Task sla reference field? if yes then only it will bring dot walked field

If you are checking with non-admin they should have read access to the task_sla table and then only it works

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Drishti]

Hey @Ankur Bawiskar ,

We only need "Business time left" field that too in the list view.

I tried populating SLA reference and then Business time left is populating.

But the challenge here is, we don't need any extra field only "Business time left " that too in list view.

I had written business rule so that it will work for new records but what about the older ones?

Please guide.

[Ankur Bawiskar]

@Drishti 

you said you required it on form. I showed with output that it's working fine.

Also you need to check if that non-admin has read access to that table i.e. task_sla

For older records you can write a fix script and populate by querying task_sla table with Task = Your Record SysId

But remember there could be multiple SLAs for your task, which one will you populate?

If my response helped please mark it correct and close the thread so that it benefits future readers.