Field Styles (color coding) on 'Duration' Column (TASK_SLA)

[strauberry]

Has anyone been able to successfully set color coding based on time remaining in SLA?

For some reason I am unable to affect the color of that field whatsoever, even using static values or null.

[#2]

Hi,

Have you convert the duration field to ms, like

javascript:current..dateNumericValue() >= 11*1000

this would color a field in the specified style if the duration is 11 seconds or more.

[strauberry]

Good idea, I went and tried it..

javascript:current.dateNumericValue() >= 11*1000

had no effect. I am starting to wonder if the special field calculations on the dictionary are preventing the style rules from being applied..

[#4 · Accepted solution]

Hi,

I see that from my previous post the a part of code disappeared most likely because I used brackets in the posted line of code which are parsed by the forum.

javascript:current..dateNumericValue() >= 11*1000

between the 2 dots fill in your duration field name

like

javascript:current.business_pause_duration.dateNumericValue() >= 11*1000

This works on a demo instance.

[strauberry]

the following solution worked.

my field name was 'duration' so the code was entered as:

javascript:current.duration.dateNumericValue() >= 11*1000

thank you for your time Laurens, have a great day!