I'm working on an incident management application where I have to filter the SLA configuration dynamically based on the incident details. It requires some advanced methods to filter the aggregate.
the below image is the incident table.
SLA condition may include any attribute from the above table like location, category, subcategory, Priority and assignment group. whenever an incident is created based on the above said attributes, from the below SLA configuration table, a matching SLA should be attached to the Incident.
(As of now, SLA table Attach condition includes only priority and Assignment group, it will include other attributes from the incident table)
Hello Kumar
As I have understood is you want to read the combination of incident attributes and accordingly you want to assign the SLA to the incident. In my opinion driving this data from table functions will be complicated and will become impossible to manage.
Instead of you can design a logic where you will give some numbers to incident based on the attribute selected and add the numbers according to the multiple attributes
You can create a static table with the Range (Numbers) and Type of SLA. Now, based on the final number assigned to the intendent you can determine SLA for it.
In this way, it will be more manageable and scalable.
I hope you got the idea or feel free to ask if you have doubts.
Hi, Thanks for the reply. Your idea sounds great. I'll try to implement this. I'll give the update if it works.