Guest User

Untitled

a guest
Mar 20th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. protected function _renderFiltersBefore()
  2. {
  3. $this->getSelect()->joinLeft(
  4. array('stock_item' => $this->getTable('cataloginventory_stock_item')),
  5. 'main_table.item_id = stock_item.item_id', array('product_id'=> 'product.sku'))
  6. ->joinLeft(
  7. array('product' => $this->getTable('catalog_product_entity')),
  8. 'stock_item.product_id = product.entity_id', array('product_sku' => 'product.sku')
  9. );
  10.  
  11. parent::_renderFiltersBefore();
  12. }
  13.  
  14. <column name="sku">
  15. <argument name="data" xsi:type="array">
  16. <item name="config" xsi:type="array">
  17. <item name="filter" xsi:type="string">text</item>
  18. <item name="label" xsi:type="string" translate="true">Sku</item>
  19. </item>
  20. </argument>
  21. </column> <column name="sku">
  22. <argument name="data" xsi:type="array">
  23. <item name="config" xsi:type="array">
  24. <item name="filter" xsi:type="string">text</item>
  25. <item name="label" xsi:type="string" translate="true">Sku</item>
  26. </item>
  27. </argument>
  28. </column>
Add Comment
Please, Sign In to add comment