I’m trying to filter orders by store instead of store view.
I have 2 stores, each has 2 store views.
I wanted to filter order with store.
I declared a collection in di.xml
<type name="MagentoFrameworkViewElementUiComponentDataProviderCollectionFactory">
<arguments>
<argument name="collections" xsi:type="array">
<item name="sales_order_grid_data_source" xsi:type="string">VendorModuleModelResourceModelOrderGridCollection</item>
</argument>
</arguments>
</type>
After that, in collection.php
like so
protected function _renderFiltersBefore()
{
$joinTable1 = $this->getTable('sales_order');
$this->getSelect()->joinLeft($joinTable1, 'main_table.entity_id = sales_order.entity_id ', ['store_id']);
parent::_renderFiltersBefore();
}
Im not sure, how to proceed