question Re: Changing Field Style for Problem Tasks if due date is passed in ITSM forum

Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 12 Mar 2020 15:22:23 GMT

I'm trying to change the font color of the due dates in the list view of PTASKS if the due date is past, but no matter what I try it doesn't seem to work.

Here's what I have now:

Table: Problem Task [problem_task]

Field Name: Due date

Value: javascript:gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) < 0 ;

Style: color:red;

What am I doing wrong?

Also, where can if find a comprehensive list of styles (colors, background, font sizes, etc.) ?

Re: Changing Field Style for Problem Tasks if due date is passed

Ashok Katam — Thu, 12 Mar 2020 15:44:39 GMT

Hi Joe

Can you try changing value to this format. Please ignore if you already tried it

javascript: var answer = gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) <  0; answer;

Thanks

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 12 Mar 2020 16:45:52 GMT

Thanks for the suggestion. This didn't work either. I think my issue is more fundamental. I tried just changing the value to just "true" to see if my style rule was even getting applied. This didn't work either. So I must be missing something basic to make the style rules active or something.

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Thu, 12 Mar 2020 17:40:30 GMT

Use this Value-

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())); answer;

I tested it works.

I usually check all exisiting style shees for reference and some you need to try if not already used in system.

-Tanaji

Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 12 Mar 2020 19:45:24 GMT

I have stopped trying to figure out the Jave script logic, because I can't even get ANY new style definition to work.

As an experiment, I tried the simplest one I could think of.

This should just turn the font for the State column red on every Problem ticket if it's "Open".

Table: Problem

Field Name: State

Value: Open

color:red;

This doesn't work! What am I missing?

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Thu, 12 Mar 2020 19:48:06 GMT

Open is the label and not backed value. Put backed value in value field (should be number value) and try.

-Tanaji
Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 12 Mar 2020 20:13:43 GMT

Ah - Very good! This is now the behavior I'm looking for.

When I set the state value to '1' instead of 'open', the state field shows up red in the list view now and not the form view.

However, this just solved my experiment only.

I'm still looking for an answer to my original question which is why my javascript for determining if a PTASK is overdue isn't working.

I've tried 3 different things:

javascript:gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) < 0 ;

javascript: var answer = gs.dateDiff(current.due_date.getDisplayValue(),gs.nowDateTime(),true) < 0; answer;

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())); answer;

None of these work.

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 12 Mar 2020 21:00:17 GMT

So right now this is working on the list view if I'm actually in the Problem ticket itself.

(See 2nd screenshot)

Table: Problem Task

Field Name: Due Date

Value:javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())); answer;

Style: background-color: red

However, I'd like this format to show up when I'm in the "Tasks" List view as well.

(1st Screenshot)

Re: Changing Field Style for Problem Tasks if due date is passed

The Machine — Fri, 13 Mar 2020 00:15:10 GMT

You’d need to add the same field style to the task table and include current.sys_class_name == ‘problem_task’

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Fri, 13 Mar 2020 12:48:49 GMT

Where do I include this? In the Value window? Like this?

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())); answer; current.sys_class_name == 'problem_task';

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Wed, 18 Mar 2020 15:15:08 GMT

Hi MB. Any guidance for my last question?

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Wed, 18 Mar 2020 16:14:06 GMT

Open the same style sheet which you created for problem_task table >> change the table to Task [task] >> insert and stay. With this you will have a copy of this style for task table.

-Tanaji
Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Wed, 18 Mar 2020 16:23:33 GMT

In case you only want it to be only for problem_task record (but visible on task and problem_task) then ignore my previous comment and update the existing style which you have on problem_task table to look like this-

Table: Task [task]
Field name: Due date
Value:

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task'; answer;

Style: background-color: red

-Tanaji
Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

The Machine — Wed, 18 Mar 2020 18:41:19 GMT

Sorry about that. Don't know how I missed that update. Tanaji's answer below should do the trick for you.

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Wed, 18 Mar 2020 19:22:02 GMT

Sweet! That last value script seems to do the trick. I'm seeing the red dot on all due dates in the past.

Hate to press my luck, but what if I don't want this style for tasks that are "Closed Complete"?

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Wed, 18 Mar 2020 19:48:57 GMT

Here's what I'm trying, but I still see the red dot on all PTASK,even those that are closed.

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state != 'Closed Complete'; answer;

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Wed, 18 Mar 2020 20:36:31 GMT

You are almost there.

Only thing you need to change is "Closed Complete". Its the label and you need to replace it with backend value of it which might be a numberical value (btw the state on problem_task has Closed [value - 157] OOTB). If you are using OOTB values then you could use

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state != '157'; answer;

Easiest way to get backend values is to get the filter you want on list view (of table required in this case task) and then right click on breadcrumbs >> Copy query. This will give you all the field names and backed values used in the filters. Use the same values in your code.

-Tanaji

Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 19 Mar 2020 13:27:41 GMT

That's awesome! Thanks for the tip about looking at values in a list view. That will really help in the future.

So here's what I have now that's working perfectly:

javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;

I then went ahead and created another style for "green":

javascript: var answer = (current.due_date.getDisplayValue() > (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task'; answer;

background-color: green

This works fine too. So with both of these every PTASK has a green or red dot.

Now I'm trying to get a little fancier.

I want to only make those PTASKS green that are more than 7 days in the future.

So I did this, but it doesn't work. No tasks show up with green dots.

javascript: var answer = (current.due_date.getDisplayValue() > 7 + (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task'; answer;

background-color: green

I'm guessing these Fields styles are evaluated sequentially and when all the conditions are met for one, it stops evaluating more. Is this correct?

So here's my logic:

Style1 (red) If due date is < current date

Style2 (green) If due date is > current date + 7 days

Style3 (yellow) If due date is > current date AND <= current date + 7 days

Re: Changing Field Style for Problem Tasks if due date is passed

Tanaji Patil — Thu, 19 Mar 2020 14:46:09 GMT

You cannot add integers to date objects directly. You need to use addDays().

Try this for green-

javascript: var gdt = new GlideDateTime(); gdt.addDays(7); var answer = (current.due_date.getDisplayValue() > gdt.getDisplayValueInternal()) && current.sys_class_name == 'problem_task'; answer;

background-color: green

Similarly for yellow try this-

javascript: var gdt = new GlideDateTime(); gdt.addDays(7); var answer = (current.due_date.getDisplayValue() > (new GlideDateTime().getDisplayValueInternal())) && (current.due_date.getDisplayValue() <= gdt.getDisplayValueInternal()) && current.sys_class_name == 'problem_task'; answer;

background-color: yellow

No, there is no order (and no order field) in evaluating these tyles. I believe it will simple pick up a random one if that happens. So make sure none of your condition is having collision with other.

I see that you have included current.state in the red style. Shouldn't it be in others as well? (Like current.state >= 3 or current.state < 3 or current.state == 3)

-Tanaji

Please mark response correct/helpful if applicable

Re: Changing Field Style for Problem Tasks if due date is passed

Joe Taylor — Thu, 19 Mar 2020 16:39:24 GMT

Thank you so much!

Everything is working exactly as I was hoping for now.

Red, Yellow and Green dots are showing up on Task View and problem view with corresponding due dates.

Here's what my 3 styles finally look like now:

Table: Task

Field Name: Due Date

Value: javascript: var answer = (current.due_date.getDisplayValue() <= (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;

background-color: red

Table: Task

Field Name: Due Date

Value: javascript: var answer = (current.due_date.getDisplayValue() > (new GlideDateTime().getDisplayValueInternal())) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;

background-color: yellow

Table: Task

Field Name: Due Date

javascript: var gdt = new GlideDateTime(); gdt.addDays(7); var answer = (current.due_date.getDisplayValue() > gdt.getDisplayValueInternal()) && current.sys_class_name == 'problem_task' && current.state < '3' ; answer;

background-color: green

Couldn't use your suggest value for "yellow" since it was too long to fit into the window.

But my three styles seem to be evaluated correctly anyway.

Thanks again