Magento 2 RightJoin Query have extra Join condition
I’m using a query to provide data for my UI component. $catalogrule = $this->getTable(‘catalogrule’); $this->getSelect() ->reset(Zend_Db_Select::COLUMNS) ->columns([‘s_id’, ‘created_at’, ‘created_by’, ‘sync_status’, ‘error’]) ->joinRight( [‘p’ =>$catalogrule], ‘main_table.magento_id = p.rule_id’, [‘entity_id’ => ‘p.rule_id’,’name’ => ‘p.name’] ) ->group(‘p.rule_id’); parent::_renderFiltersBefore(); but when I print this… Read More »Magento 2 RightJoin Query have extra Join condition