Questions tagged [collection]

Questions related to Magento collections

Filter by
Sorted by
Tagged with
2
votes
1answer
15 views

Magento 2: How to load data by Page same collection object?

I am using \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory and loading data by creating objects. $collection = $this->collectionFactory->create() ->...
0
votes
0answers
13 views

magento 2 how to add search box to fronted for a custom table contents

How to add a frontend search box for a custom table contents. When the user enters three letters of a name then get data in pop up. Anyone Can help? Thank you in advance.
1
vote
0answers
20 views

How i can work with extension attributes using collection?

Hello i have to add extension attributes to Magento\Catalog\Api\Data\ProductInterface So i added this one to extension_attrributes.xml: <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
1
vote
2answers
44 views
+50

Magento2 Need to filter grid when value is entered in search box, the column of the data is from another table

I have added 4 columns in the grid as displayed in below screenshot. For displaying for eg. Recipient Email column I added following code in XML & it's renderer PHP file. (Code is added below) ...
0
votes
1answer
25 views

Magento 2: How to filter orders by order items

In magento 1, I was able to filter orders by the following: $orderitem = Mage::getModel('sales/order_item')->getCollection(); $orderitem->addFieldToFilter('name',array('like'=>'%'.$value.'%')...
0
votes
0answers
14 views

Magento 2 collection filters for GRID are not working

I'm developing a module for Magento 2, but when trying to create a GRID, my filters are not working. I have some settings in other class and load it to the collection, using it inside the ...
0
votes
1answer
13 views

magento 1.9 | how setStockData on collection

i have this code $productCollection = Mage::getModel('catalog/product')->getCollection(); $productCollection->addAttributeToSelect('SKU') ->addAttributeToFilter('...
1
vote
3answers
27 views

Magento 2 + custom eav field value store in array

I have a custom eav structure and there is store_id save in array format in the database field. I need to filer collection with addFieldToFilter with store_id. $collection = $this->...
2
votes
0answers
8 views

How to create a pagination on product page for the reviews

I am trying to create pagination on product page just to keep the review down. I have over 50 reviews for product is there anyway I could limit it to 10. Is there anyway I could follow some codes or ...
1
vote
1answer
20 views

How add new item in existing collection in magento 2

i have 2 collections 1 Orders 0 date "2019-07-05" count "2" 1 date "2019-06-20" count "2" 2 date "2019-06-18" count "2" 3 date "2019-06-17" count "2" 4 date "...
2
votes
6answers
195 views

Date Range filter not working in custom Grid Magento 2

I have created the custom sales report using ui component. Grid is loading correctly. I have added the date range filter as like below. <column name="created_at" class="Magento\Ui\Component\...
0
votes
1answer
28 views

Magento 2 - how to use count and group by clause in collection

i have order collection and want to this query result like `SELECT `created_at`,COUNT(`entity_id`) FROM `sales_order_item` GROUP BY `created_at`; i use this query `$selectCollection=$this->...
0
votes
3answers
28 views

Set order for product Collection in magento2

I am filtering product collection like below. $productSkuString = 'O, C, D, A, F, S'; $productSkus = explode(', ', $productSkuString); $collection = $this->collectionFactory-&...
1
vote
2answers
21 views

difference in result of count and getSize()

I am preparing the product collection as follows $visibleProducts = $this->catalogProductVisibility->getVisibleInCatalogIds(); $collection = $this->productCollectionFactory->create(); $...
2
votes
1answer
22 views

Magento catalog price rule

How to get product based on conditions on catalog rule in magento2? By product model products are received but how to apply filter to get only those product based on conditions. Any help will be ...
0
votes
0answers
23 views

Magento 2 create new tab and add customer grid collection on product add/edit page in admin

I am using magento 2.3 and i want add custom tab in Product edit page on admin and add grid collection of customer in custom tab. So any one know How i can do that. Thank you.
1
vote
1answer
34 views

Magento 2: How to add multilevel AND and OR conditions to searchCriteria?

What i want to achieve is this - attr1 = 'val1' AND attr2 = 'val2' AND ((attr_s1 = 'val_s1' AND attr_d1 = 'val_d1' AND attr_t1 = 'val_t1') OR (attr_s2 = 'val_s2' AND attr_d2 = 'val_d2' AND ...
0
votes
0answers
17 views

Magento 2 product collection getSelect Order by Case unException Unknown column 'name' in 'order clause'

I need to use ORDER BY CASE name which is product name Query: SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `...
3
votes
1answer
48 views

Magento 2 Updating Other Products in catalog_product_save_after event Observer

I had created an Observer of this event:catalog_product_save_after I am trying to update other products and loading them on the basis of their id, but it is giving me an error. I am Sharing my code ...
0
votes
1answer
33 views

Magento 2: How to get sub category and their products in collection?

I want to get the categories and related products in collection using parent category ID. So that i can show the grid like sub category 1 sub category 1's product 1 sub category 1's product 2 sub ...
3
votes
2answers
62 views

collection, get product image

Sorry for my English I have this code $productCollection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('short_description') ->...
2
votes
1answer
26 views

Difference between $this->getData() or $this->getResource()

In my Collection.php when i get the collection by $this->getData() is give me collection. But it create some other problem for me . Now i use $this->getResource() then problem solved But it ...
0
votes
2answers
28 views

Magento 1 | how get product attribute data

Sorry for my English. I have this code. $productCollection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToFilter('attribute_set_id',array(12,4)) ...
0
votes
1answer
14 views

Magento1 | Collection how get all products where qty > 1, build query

I have this code $productCollection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToFilter('attribute_set_id',array(12,4)) ->setPageSize(...
3
votes
1answer
33 views

Magento 2: Getting unknown category

I am trying to get a level 2 category list. I got all level 2 categories but I am also getting 2 unknown categories which are not in backend. This is weird. Here is my code public function ...
0
votes
0answers
16 views

Difference between Magento Collection ,object , array

Please clear the main difference between Magento Collection , object , array and arraylist also ?
0
votes
0answers
17 views

How to get magento2 bundle products in list page

How to get magento2 bundle products in category list page. I assigned to category but not visible in frontend. Thanks
0
votes
1answer
45 views

recently viewed product collection is empty in magento 2

I have added a code in Magento_Catalog/layout/catalog_product_view.xml <referenceBlock name="product.info.details"> <block class="Magento\Reports\Block\Product\Widget\Viewed" name="...
1
vote
1answer
29 views

How is a product name retrieved if the query does not return it in the result set?

I'm trying to get data from catalog_product EAV tables with the following code: $productCollection = Mage::getModel('catalog/product')->getCollection() ->addAttributeToFilter('...
0
votes
1answer
23 views

Why magento2 outputs the query while showing data from ResourceModel collection Factory..?

protected $productCollectionFactory; public function __construct( ..... \Custom\MyModule\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory, ... ) { ...
0
votes
0answers
11 views

Collection array attribute value change on run time

i have a collection [0] => Array ( [entity_id] => 93 [state] => complete [subtotal_invoiced] => 3445.0000 [total_invoiced] => ...
0
votes
2answers
39 views

I need to filter product collection by category id and color attribute

I need to get product collection by category id and color attribute. But It's not working. Here is my code: $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $categoryFactory = $...
0
votes
1answer
25 views

Sort product collection on stock status in magento2.3

I want to sort my list.phtml and catalogsearch by availability. Mean that when category page or search result page loads, first show "in stock" product and at the end show out of stock items. Don't ...
0
votes
1answer
23 views

Magento2 admin grid: SQL error when sorting by specific field

Database table columns are displayed in custom grid in adminhtml. One of the field has name 'precision' and this causes SQL error when I sort the grid by this field (as this is mysql reserved word and ...
2
votes
1answer
85 views

Magento 2 - All products attributes updated after update from collection

I have got collection in $collecction from Magento\Catalog\Model\ResourceModel\Product\CollectionFactory with some certain conditions I am updating a custom attribute viewed_count in foreach loop ...
0
votes
0answers
23 views

Set a default filter for Order Grid

How can I set a default filter for Order Grid programmatically? I read many different answer but they don't work properly.
2
votes
1answer
50 views

Magento 2 - Need to filter comma seprated values in addAttributeToFilter along with category filter

I need to filter comma sperated values in addAttributeToFilter in magento 2 Here is my Code: $comma_separated_values = 26,27,28,29; $categoryProducts = $category->getProductCollection()->...
0
votes
3answers
45 views

custom table left join with catalog/product

I have a custom table called flagged_products which lists flagged products like this: +-----------+------------+---------------------+ | entity_id | product_id | flagged_on | +-----------+---...
1
vote
1answer
17 views

How to get product random collection in magento2?

I want to get the random 10 products from whole product collection in magento2. $productCollection = $this ->productModel ->getProductCollection() ->...
0
votes
1answer
32 views

array convert into Magento 2 collection

I have 2 collection 1 is $bestsalecollection that show in dashboard . second is product collection. After filter collection when i return it generate error Call to a member function isLoaded() on ...
0
votes
0answers
24 views

Why product collection query not showing “color” attribute in select?

Case 1: $collection = $this->product->getCollection() ->addAttributeToSelect('color'); echo $collection->getSelect()->__toString(); Output: SELECT `e`.* FROM `...
3
votes
1answer
42 views

Custom FilterList incorrectly sets Collection size in Layered Navigation

In order to add a custom filter to the Layered Navigation, I overrode the class Magento\LayeredNavigation\Block\Navigation\Category to load my own FilterList class instead of the one from core. My ...
1
vote
1answer
25 views

Magento 2 - Recently viewed product collection from Model

Please read description carefully before marking it as duplicate I want to get recently viewed product collection from Model instead of Block I have check similar post but no one answered it ...
0
votes
0answers
13 views

Incorrect product sorting for numerical attributes (Magento 2.2.8)

I've got a shop with an attribute "capacity" created via Magento Backend: Shops -> Attribute -> Product It has "Text Field" as input type and "Decimal" as validation. So for new products therefore ...
0
votes
0answers
24 views

Set custom Record Count to Collection pagination in Report Grid

How we can set count of collection size before setting for the grid. Main Sales collection: $collection=Mage::getModel('sales/order')->getCollection() ->addAttributeToFilter('created_at', ...
3
votes
2answers
73 views

Magento 2.3 - Add product name column in custom ui grid with product name filter

I have added product name column in my custom ui grid. In which data displayed properly but not filtered grid by product name. Note : I set product name with comma separated in ui grid column. Here ...
2
votes
1answer
29 views

Magento 2 - Multiple collection on same block

I have a block where I want 3 different collections with different category filters. I have created collection object in constructor like this: protected $collection; public function __construct( ...
0
votes
0answers
20 views

Magento 1.9.3.1 Sales Order Grid limit records

I have a Magento store running with over 18,000 order records all the other pages within admin load within 1 - 2 seconds apart from Sales>Orders this can take anything between 5 - 20 seconds to load. ...
3
votes
1answer
19 views

Magento 2 - Multiple categories filter on product collection

I have a product collection $collection which is created by Magento\Catalog\Model\ResourceModel\Product\Collection code is: $collection = $objectManager->create('Magento\Catalog\Model\...
0
votes
0answers
28 views

Magento 2.3 custom conditions for attribute filter using addAttributeToFilter

In Magento 2.3 I need to filter the collection as per below scenario. I have L, W and H attributes for products And user input is "X, Y and Z" then the following condition will give the desired ...