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->ordercollection->create()->addFieldToSelect('entity_id')->addFieldToSelect('created_at');
$querycollection=$selectCollection->getSelect('COUNT(`entity_id`)')->group('created_at');`
But not work
Just i want to get how many orders come on each date or every day ?
Best Answer
Something like this
If you want to do it as part of a factory collection same methods apply. Just slightly different syntax.
Magento 2: Select Field From Collection Query