I have a two tables one is main table, one is SLA table
so I need to map the data based on type and task status I need to show the numbers . attached excel is the sample data
I explained with example in sheet1
can anyone suggest the way to achieve this?
thanks for your attempt Antonio . But that is not my expected result. it is showing all the tickets
but I need only the ticket status value is greater than main table data rest it should not be shown in table.
Could guide on that way?
example: SLA table
ZAA - OS (Configure )
|MM15343678||Order||SCTASK5415502||ZAA - OS (Configure )||Medium||Open|
in above record elopse time in main table is greater than Sla table status Medium so it is displaying but if it is less than that it should not be displayed in table:
instead of 612078 if you put 30000 still the ticket is showing.