Get collection of orders excluding cancelled order in Magento 2
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have got order collection with the following code:
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
Which is working fine. Problem is that it returns all types of orders including 'processing', 'cancelled' etc. I don't want the cancelled order in this collection.
I don't know how to exclude cancelled order in the above code.
Hope somebody helps.
magento2.2 order-collection
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
add a comment |
I have got order collection with the following code:
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
Which is working fine. Problem is that it returns all types of orders including 'processing', 'cancelled' etc. I don't want the cancelled order in this collection.
I don't know how to exclude cancelled order in the above code.
Hope somebody helps.
magento2.2 order-collection
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
add a comment |
I have got order collection with the following code:
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
Which is working fine. Problem is that it returns all types of orders including 'processing', 'cancelled' etc. I don't want the cancelled order in this collection.
I don't know how to exclude cancelled order in the above code.
Hope somebody helps.
magento2.2 order-collection
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
I have got order collection with the following code:
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
Which is working fine. Problem is that it returns all types of orders including 'processing', 'cancelled' etc. I don't want the cancelled order in this collection.
I don't know how to exclude cancelled order in the above code.
Hope somebody helps.
magento2.2 order-collection
magento2.2 order-collection
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
asked 15 hours ago
Arshad HussainArshad Hussain
4071826
4071826
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Try this,
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));
Status not in cancelled order will get into the collection.
am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
add a comment |
It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:
use MagentoSalesModelResourceModelOrderCollectionFactory;
class SomeClass
{
...
public function __construct(
...
CollectionFactory $orderCollectionFactory
...
) {
...
$this->collectionFactory = $orderCollectionFactory;
...
}
...
public function getOrders(){
$orders = $this->collectionFactory()->create()
->addFieldToSelect('*')
->addFieldToFilter('status', ['neq' => 'cancelled']);
return $orders;
}
}
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268790%2fget-collection-of-orders-excluding-cancelled-order-in-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try this,
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));
Status not in cancelled order will get into the collection.
am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
add a comment |
Try this,
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));
Status not in cancelled order will get into the collection.
am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
add a comment |
Try this,
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));
Status not in cancelled order will get into the collection.
am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
Try this,
$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));
Status not in cancelled order will get into the collection.
am not sure about the status name cancelled make sure you use the exact one in the table sales_order table.
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
edited 15 hours ago
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
answered 15 hours ago
Prathap GunasekaranPrathap Gunasekaran
1,6621618
1,6621618
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
add a comment |
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
– Arshad Hussain
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
sorry typo erro check now
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
Is it working??
– Prathap Gunasekaran
15 hours ago
add a comment |
It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:
use MagentoSalesModelResourceModelOrderCollectionFactory;
class SomeClass
{
...
public function __construct(
...
CollectionFactory $orderCollectionFactory
...
) {
...
$this->collectionFactory = $orderCollectionFactory;
...
}
...
public function getOrders(){
$orders = $this->collectionFactory()->create()
->addFieldToSelect('*')
->addFieldToFilter('status', ['neq' => 'cancelled']);
return $orders;
}
}
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
add a comment |
It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:
use MagentoSalesModelResourceModelOrderCollectionFactory;
class SomeClass
{
...
public function __construct(
...
CollectionFactory $orderCollectionFactory
...
) {
...
$this->collectionFactory = $orderCollectionFactory;
...
}
...
public function getOrders(){
$orders = $this->collectionFactory()->create()
->addFieldToSelect('*')
->addFieldToFilter('status', ['neq' => 'cancelled']);
return $orders;
}
}
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
add a comment |
It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:
use MagentoSalesModelResourceModelOrderCollectionFactory;
class SomeClass
{
...
public function __construct(
...
CollectionFactory $orderCollectionFactory
...
) {
...
$this->collectionFactory = $orderCollectionFactory;
...
}
...
public function getOrders(){
$orders = $this->collectionFactory()->create()
->addFieldToSelect('*')
->addFieldToFilter('status', ['neq' => 'cancelled']);
return $orders;
}
}
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
It isn't the best way to get collections in M2 using object manager. Use collection factorty for this purpose instead. Here's a short example:
use MagentoSalesModelResourceModelOrderCollectionFactory;
class SomeClass
{
...
public function __construct(
...
CollectionFactory $orderCollectionFactory
...
) {
...
$this->collectionFactory = $orderCollectionFactory;
...
}
...
public function getOrders(){
$orders = $this->collectionFactory()->create()
->addFieldToSelect('*')
->addFieldToFilter('status', ['neq' => 'cancelled']);
return $orders;
}
}
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
edited 14 hours ago
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
answered 15 hours ago
Kirill KorushkinKirill Korushkin
1437
1437
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268790%2fget-collection-of-orders-excluding-cancelled-order-in-magento-2%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
