Service Desk Practitioners Forum
cancel

Actual finish is greater than deadline -view

Highlighted
Kalpana Muundhe
New Member.

Actual finish is greater than deadline -view

Hi,

I want to create a view , where in all sevice calls/incidents will be displayed whose actual finish is greater than deadline.

please help me to implement this.

thanks,
Kalpana
6 REPLIES
The Pike
Acclaimed Contributor.

Re: Actual finish is greater than deadline -view

In SD4.5, you cannot compare one field to another in a filter, so it cannot be done.

I am not sure if you can do it or not in other versions.

Do not forget to assign points...

The Pike
Alain_18
Respected Contributor.

Re: Actual finish is greater than deadline -view

Hi,

You can filter on the field "to deadline".
Evey item below 0 is greater than deadline.
Kalpana Muundhe
New Member.

Re: Actual finish is greater than deadline -view

Thanks Alain,

This helped to get a view with -values 'to deadline' but along with negative it is also displaying + values.

i want a view only for service calls which has actual finish more than deadline.

PS: i have awarded points already.

Thanks,
Kalpana
Alain_18
Respected Contributor.

Re: Actual finish is greater than deadline -view

Hi again,

You could have an UI rule firing when status goes to closed uppdating a duration custom field of yours which is the result of "deadline - actual finish".
Then you can filter your view with this custom field less than 1 minute (it doesn't take 0)
The Pike
Acclaimed Contributor.

Re: Actual finish is greater than deadline -view

If you were to work around it using a Rule, I'd suggest setting up a DB or UI Rule as Alain suggests but instead of subtracting and using a numeric value to compare to, simply add a boolean custom field (which you could name 'Actual Finish past Deadline?').

In Business Logic Rules, you can compare two fields. For example, you could set a condition to be:

When Service Call is modified
Where Actual Finish on or after (Field)Deadline

And then, you can filter the View by the boolean field.

Hope this helps.
Points are welcome.

The Pike
The Pike
Acclaimed Contributor.

Re: Actual finish is greater than deadline -view

Forgot to mention the obvious... you need to update the boolean field in the rule.

Points are welcome.
The Pike