How to filter tasks that are created without SLA?

[Onoderav]

Hi, guys! 

I need some help, please. Have you ever seen something like this?

Customer required to create SLA to any new tasks created (from catalog task and incident task table) that don't have SLA defined at the beginning. I know that the best way is to attach the SLA directly to the item, but in this case, they asks us to identify tasks that don't have SLA defined and them, attach this SLA. I don't know how to filter those tasks that are created without SLA. 

Is it a good practice? Is it possible?

Do I make myself clear? 

[Revanth Karra]

Dear Onoderav,

Hi @Onoderav . Hope you're doing great! 

Yes, it is possible to filter tasks that are created without an SLA defined. You can do this by using the following steps:

1. Create a new filter on the sc_task or incident table.
2. In the filter condition, add the following criteria:

SLA = NULL

This will filter all tasks that do not have an SLA defined.

Once you have created the filter, you can use it to identify and attach the SLA to the tasks. You can do this by manually attaching the SLA to each task and you can also use the script to automate the process as well.

Kindly, please mark my solution as Helpful/Correct, if applicable. If I could help you with your Query then, please hit the Thumb Icon and mark as Correct!!

Thanks & Regards, 

Revanth. K

Product Test Automation Engineer

[Onoderav]

Hi, @Revanth Karra. Thanks for reply
Are you refering to the condition builder?
I've tried this filter, but there's no 'SLA' option to set to null in the condition builder or something like that.

I've tried the natural languague filter too, but didn't work as well.