Mdtryhht

I'm flying to France today and my passport expires in less than 2 months

Will google still index a page if I use a $_SESSION variable?

Why doesn't H₄O²⁺ exist?

What killed these X2 caps?

Is the Joker left-handed?

What is the word for reserving something for yourself before others do?

Why does Kotter return in Welcome Back Kotter

How can I make my BBEG immortal short of making them a Lich or Vampire?

Etiquette around loan refinance - decision is going to cost first broker a lot of money

Should I tell management that I intend to leave due to bad software development practices?

Famous Pre Reformation Christian Pastors (Non Catholic and Non Orthodox)

Is it possible to create light that imparts a greater proportion of its energy as momentum rather than heat?

Why are electrically insulating heatsinks so rare? Is it just cost?

90's TV series where a boy goes to another dimension through portal near power lines

Could gravitational lensing be used to protect a spaceship from a laser?

What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?

Stopping power of mountain vs road bike

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

What's the difference between 'rename' and 'mv'?

What to put in ESTA if staying in US for a few days before going on to Canada

Fully-Firstable Anagram Sets

How badly should I try to prevent a user from XSSing themselves?

Why is consensus so controversial in Britain?

Can I ask the recruiters in my resume to put the reason why I am rejected?

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 10 hours ago

Arshad HussainArshad Hussain

4071826

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 10 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

share|improve this question

asked 10 hours ago

Arshad HussainArshad Hussain

4071826

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

share|improve this question

asked 10 hours ago

Arshad HussainArshad Hussain

4071826

share|improve this question

asked 10 hours ago

Arshad HussainArshad Hussain

4071826

asked 10 hours ago

Arshad HussainArshad Hussain

4071826

asked 10 hours ago

Arshad HussainArshad Hussain

4071826

2 Answers
2

active

oldest

votes

2

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.

share|improve this answer

edited 10 hours ago

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is it working??
  
  – Prathap Gunasekaran
  10 hours ago
  

  
  
  
  

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 9 hours ago

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



);

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

2

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.

share|improve this answer

edited 10 hours ago

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is it working??
  
  – Prathap Gunasekaran
  10 hours ago
  

  
  
  
  

add a comment | 

2

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.

share|improve this answer

edited 10 hours ago

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Call to undefined method MagentoSalesModelResourceModelOrderCollection::addFieldToField()
  
  – Arshad Hussain
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry typo erro check now
  
  – Prathap Gunasekaran
  10 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is it working??
  
  – Prathap Gunasekaran
  10 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.

share|improve this answer

edited 10 hours ago

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

$orders = $objectManager->create('MagentoSalesModelOrder')->getCollection();
$orders->addFieldToSelect('*')->addFieldToFilter('status', array('neq' => 'cancelled'));

share|improve this answer

edited 10 hours ago

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

answered 10 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,6621618

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 9 hours ago

answered 10 hours ago

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 9 hours ago

answered 10 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;
 

share|improve this answer

edited 9 hours ago

answered 10 hours ago

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 9 hours ago

answered 10 hours ago

Kirill KorushkinKirill Korushkin

1437

answered 10 hours ago

Kirill KorushkinKirill Korushkin

1437

answered 10 hours ago

Kirill KorushkinKirill Korushkin

1437