Joins are not working on the Update
I have two fields joined together in the data source. While making fetch it works perfectly. But while making the update call the DSReqest is unable to figure out joined columns.
Query formed for fetch
SELECT * FROM coc LEFT OUTER JOIN vendor_material change_vendor_material_id ON coc.change_vendor_material_id = change_vendor_material_id.vendor_material_id WHERE ( (change_vendor_material_id.vendor_id IN ( -55 ) )
But when I make the update Query formed
UPDATE coc SET comment='comment' WHERE (change_vendor_material_id.vendor_id IN ( -55 ) )
I passed the same criteria to both update and the fetch call
I have two fields joined together in the data source. While making fetch it works perfectly. But while making the update call the DSReqest is unable to figure out joined columns.
Query formed for fetch
SELECT * FROM coc LEFT OUTER JOIN vendor_material change_vendor_material_id ON coc.change_vendor_material_id = change_vendor_material_id.vendor_material_id WHERE ( (change_vendor_material_id.vendor_id IN ( -55 ) )
But when I make the update Query formed
UPDATE coc SET comment='comment' WHERE (change_vendor_material_id.vendor_id IN ( -55 ) )
I passed the same criteria to both update and the fetch call
Comment