Moving data from one table to another
I have one booolean field "phResolveSLABreached" in table "incidents".
And 2 fields in "sloresponse" table. i.e slo.name(character) and breached(boolean).
-> Now there are some interaction where slo is attached with name starts with "SLA RESOLUTION" or "OLA RESOLUTION".
-> And this is captured in "sloresponse" table in slo.name field. (slo.name#SLA RESOLUTION or slo.name#OLA RESOLUTION).
->There is one more field in "sloresponse" table called breached.
Now I want if for any interaction ticket slo.name starts with above then the value of "breached" in sloresponse table should be updated on related interaction ticket.
Can someone help???
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)