Skip to content

magento man

No grouped items on OrderRepositoryInterface

I try to get all products items from MagentoSalesApiOrderRepositoryInterface but i get simples products instead of grouped product. Everything is right with configurables $criteria = $this->searchCriteriaBuilder ->addFilter(‘created_at’, $from, ‘gteq’) ->addFilter(‘created_at’, $to, ‘lteq’) ->addFilter(‘store_id’, $storeId,’eq’) ->addFilter(‘status’, $status,’eq’) ->create(); $orderResult = $this->orderRepository->getList($criteria);… Read More »No grouped items on OrderRepositoryInterface

error on left join

I’m getting errors in Left join, below is my code. $motorcyclebookFactory = $this->motorcyclebookFactory->create() ->getCollection() ->addFieldToFilter(‘product_id’, $productCollectionData->getId()); $motorcyclebookFactory->getSelect()->joinLeft( ‘rider_detail as wrd’, ‘wrd.booking_id = main_table.booking_id’, [‘booking_id’, ‘booking_series_id’] ); Error is { “code”: “500”, “message”: “SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘product_id’ in… Read More »error on left join