areski wrote:
using mysql!
Enable class table debug and catch the query generated on batch update of sell price of rates selected after search by prefix rates. Will your query the same or similar to mine?
UPDATE cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id SET rateinitial = rateinitial +'0.005' WHERE cc_tariffgroup.id= '1' AND cc_ratecard.rateinitial = (SELECT min(c1.rateinitial) FROM cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard AS c1 ON c1.idtariffplan=cc_tariffplan.id WHERE cc_tariffgroup.id= '1' AND cc_ratecard.dialprefix=c1.dialprefix);
To be honest with you, I don't understand why select subquery is needed. I need to update sell rates on a single rate card, why cc_tariffplan, tariffgroup tables are involved to the query?