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???