Mrthdrb

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

How can the DM most effectively choose 1 out of an odd number of players to be targeted by an attack or effect?

Banach space and Hilbert space topology

How to get the available space of $HOME as a variable in shell scripting?

Why are only specific transaction types accepted into the mempool?

Why can't I see bouncing of a switch on an oscilloscope?

Why don't electromagnetic waves interact with each other?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

Patience, young "Padovan"

Is it possible to make sharp wind that can cut stuff from afar?

Question about Goedel's incompleteness Proof

Book about a traveler who helps planets in need

How is this relation reflexive?

How long does it take to type this?

Why don't electron-positron collisions release infinite energy?

Compute hash value according to multiplication method

XeLaTeX and pdfLaTeX ignore hyphenation

A function which translates a sentence to title-case

How is it possible to have an ability score that is less than 3?

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Japan - Plan around max visa duration

How can I hide my bitcoin transactions to protect anonymity from others?

If Manufacturer spice model and Datasheet give different values which should I use?

Is the month field really deprecated?

Get collection of orders excluding cancelled order in Magento 2

Orders collection - how to get all in the time range (current day)Order mail from success.phtml page in magento 2.2?Magento 2 - Get orders that were completed x days agoHow to get the selected Order(s) so i can use them for building a form in custom grid?Magento v1.9 Customer Edit Tab - Orders Collection{M1) Product collection sort order by views for Most Viewed ProductsMagento 2 : How to get order collection group by customer?How to get order collection filter with customer_is_guest and email (Magento 2)Get order collection by order id in Magento 2?Get billing address line 1 and line 2 in order collection: 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

4361826

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

4361826

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

4361826

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

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4361826

share|improve this question

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4361826

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4361826

asked Apr 4 at 12:54

Arshad HussainArshad Hussain

4361826

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 2 days ago

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  2 days ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  2 days ago
  

  
  
  
  

 | 
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 2 days ago

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  2 days ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  2 days ago
  

  
  
  
  

 | 
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 2 days ago

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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
  2 days ago
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Will it returns collection
  
  – Prathap Gunasekaran
  2 days ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It is returning collection including all types of status
  
  – Arshad Hussain
  2 days ago
  

  
  
  
  

 | 
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 2 days ago

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

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

share|improve this answer

edited 2 days ago

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

answered Apr 4 at 13:02

Prathap GunasekaranPrathap Gunasekaran

1,7261618

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