Trjtdtk

When speaking, how do you change your mind mid-sentence?

Why does my GNOME settings mention "Moto C Plus"?

Will I be more secure with my own router behind my ISP's router?

2 sample t test for sample sizes - 30,000 and 150,000

How to produce a PS1 prompt in bash or ksh93 similar to tcsh

What's the connection between Mr. Nancy and fried chicken?

Are Flameskulls resistant to magical piercing damage?

Should man-made satellites feature an intelligent inverted "cow catcher"?

Can gravitational waves pass through a black hole?

How to leave only the following strings?

A journey... into the MIND

Married in secret, can marital status in passport be changed at a later date?

How can I introduce the names of fantasy creatures to the reader?

Lights are flickering on and off after accidentally bumping into light switch

Knights and Knaves question

Providing direct feedback to a product salesperson

Putting Ant-Man on house arrest

Converting a text document with special format to Pandas DataFrame

Why does BitLocker not use RSA?

What is the evidence that custom checks in Northern Ireland are going to result in violence?

Assertions In A Mock Callout Test

Is Vivien of the Wilds + Wilderness Reclamation a competitive combo?

Im stuck and having trouble with ￢P ∨ Q Prove: P → Q

A German immigrant ancestor has a "Registration Affidavit of Alien Enemy" on file. What does that mean exactly?

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;

1

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

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

add a comment | 

1

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

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

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

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4571928

2 Answers
2

active

oldest

votes

3

Try this,

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

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.

share|improve this answer

edited Apr 5 at 10:49

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  Apr 4 at 13:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  Apr 4 at 13:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked it in db for status, its 'canceled' but still it is not working niether yours nor mine.
  
  – Arshad Hussain
  Apr 5 at 10:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  Apr 5 at 10:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  Apr 5 at 10:45
  

  
  
  
  

 | 
show 3 more comments

2

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;
 

share|improve this answer

edited Apr 4 at 13:57

answered Apr 4 at 13:39

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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

3

Try this,

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

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.

share|improve this answer

edited Apr 5 at 10:49

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  Apr 4 at 13:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  Apr 4 at 13:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked it in db for status, its 'canceled' but still it is not working niether yours nor mine.
  
  – Arshad Hussain
  Apr 5 at 10:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  Apr 5 at 10:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  Apr 5 at 10:45
  

  
  
  
  

 | 
show 3 more comments

3

Try this,

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

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.

share|improve this answer

edited Apr 5 at 10:49

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  Apr 4 at 13:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  Apr 4 at 13:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked it in db for status, its 'canceled' but still it is not working niether yours nor mine.
  
  – Arshad Hussain
  Apr 5 at 10:42
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  Apr 5 at 10:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  Apr 5 at 10:45
  

  
  
  
  

 | 
show 3 more comments

Try this,

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

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.

share|improve this answer

edited Apr 5 at 10:49

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('in' => array(complete,processing)));

share|improve this answer

edited Apr 5 at 10:49

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,9021618

2

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;
 

share|improve this answer

edited Apr 4 at 13:57

answered Apr 4 at 13:39

Kirill KorushkinKirill Korushkin

1437

add a comment | 

2

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;
 

share|improve this answer

edited Apr 4 at 13:57

answered Apr 4 at 13:39

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;
 

share|improve this answer

edited Apr 4 at 13:57

answered Apr 4 at 13:39

Kirill KorushkinKirill Korushkin

1437

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;
 

share|improve this answer

edited Apr 4 at 13:57

answered Apr 4 at 13:39

Kirill KorushkinKirill Korushkin

1437

answered Apr 4 at 13:39

Kirill KorushkinKirill Korushkin

1437

answered Apr 4 at 13:39

Kirill KorushkinKirill Korushkin

1437