SELECT *,price_formula->>'$.firstcolumn' as firstcolumn,price_formula->>'$.exchangerate' as exchangerate,price_formula->>'$.commission' as commission,price_formula->>'$.calculationtype' as calculationtype FROM account_master where refrence_code='MBB' AND status=1 AND is_deleted=0 AND sync_product='1'

Tags: