Ggtkuk

Instead of Universal Basic Income, why not Universal Basic NEEDS?

Professor being mistaken for a grad student

Running a subshell from the middle of the current command

Function to parse .NET composite string format

Did CPM support custom hardware using device drivers?

Life insurance that covers only simultaneous/dual deaths

My story is written in English, but is set in my home country. What language should I use for the dialogue?

How to deal with a cynical class?

What do these Greek words say? Possibly 2nd century

Does splitting a potentially monolithic application into several smaller ones help prevent bugs?

Am I not good enough for you?

How could a scammer know the apps on my phone / iTunes account?

Replacing Windows 7 security updates with anti-virus?

About parabolic Kazhdan Lusztig polynomials

Is a lawful good "antagonist" effective?

Rules about breaking the rules. How do I do it well?

Why doesn't the EU now just force the UK to choose between referendum and no-deal?

Making a sword in the stone, in a medieval world without magic

Can the damage from a Talisman of Pure Good (or Ultimate Evil) be non-lethal?

Brexit - No Deal Rejection

Be in awe of my brilliance!

Ban on all campaign finance?

It's a yearly task, alright

Counting certain elements in lists

how to use filters for new collection

Magento 2 Custom CollectionDealing with collections from my model in Magento 2Call to undefined method on custom collection Resource ModelMagento 2 Add new field to Magento_User admin formWhat preference to use for MagentoFrameworkDBAdapterAdapterInterface?Magento offline custom Payment method with drop down listError in collectionsunable to solve the error in magento2PHP Fatal error: Uncaught TypeError: Argument 1 passed to Magento\Framework\Data\Collection\AbstractDb::setConnection() must implement interfaceIncompatible argument type error during compilation in Magento2.2.5?Declaration error during compile

2

I use in my decision the answer that was in this question
Magento 2 Custom Collection

Everything works fine, but how to filter data when they are searched?

My code

$collection = $this->_postFactory->create()->getCollection();

 $collection2 = $this->_purchaseListCollection;

 foreach ($collection->getData() as $key => $data) 
 $data['model_number'] = 'tested'.$key;
 $collection2->addItem(
 new MagentoFrameworkDataObject($data)
 );
 

 $this->setCollection($collection2);

 return parent::_prepareCollection();

Code create table

 $this->addColumn(
 'model_number',
 [
 'header' => __('Model number'),
 'index' => 'model_number',
 'sortable' => true,
 'type' => 'text',
 'escape' => true,
 'header_css_class' => 'col-value',
 'column_css_class' => 'col-value',
 ]
 );

My code on model/resourceModel collection

namespace MagentoPurchaseWizardModelResourceModelPurchaseList;

use MagentoFrameworkDataCollection as DataCollection;
class EmptyCollection extends DataCollection

magento2 collection

share|improve this question

edited 5 hours ago

Denis Maksiura

asked yesterday

Denis MaksiuraDenis Maksiura

114

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please upload your code.
  
  – Rohan Hapani
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i edit my question
  
  – Denis Maksiura
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Provided answer try it and let me know @DenisMaksiura
  
  – Prathap Gunasekaran
  9 hours ago
  

  
  
  
  

add a comment | 

2

I use in my decision the answer that was in this question
Magento 2 Custom Collection

Everything works fine, but how to filter data when they are searched?

My code

$collection = $this->_postFactory->create()->getCollection();

 $collection2 = $this->_purchaseListCollection;

 foreach ($collection->getData() as $key => $data) 
 $data['model_number'] = 'tested'.$key;
 $collection2->addItem(
 new MagentoFrameworkDataObject($data)
 );
 

 $this->setCollection($collection2);

 return parent::_prepareCollection();

Code create table

 $this->addColumn(
 'model_number',
 [
 'header' => __('Model number'),
 'index' => 'model_number',
 'sortable' => true,
 'type' => 'text',
 'escape' => true,
 'header_css_class' => 'col-value',
 'column_css_class' => 'col-value',
 ]
 );

My code on model/resourceModel collection

namespace MagentoPurchaseWizardModelResourceModelPurchaseList;

use MagentoFrameworkDataCollection as DataCollection;
class EmptyCollection extends DataCollection

magento2 collection

share|improve this question

edited 5 hours ago

Denis Maksiura

asked yesterday

Denis MaksiuraDenis Maksiura

114

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please upload your code.
  
  – Rohan Hapani
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i edit my question
  
  – Denis Maksiura
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Provided answer try it and let me know @DenisMaksiura
  
  – Prathap Gunasekaran
  9 hours ago
  

  
  
  
  

add a comment | 

I use in my decision the answer that was in this question
Magento 2 Custom Collection

Everything works fine, but how to filter data when they are searched?

My code

$collection = $this->_postFactory->create()->getCollection();

 $collection2 = $this->_purchaseListCollection;

 foreach ($collection->getData() as $key => $data) 
 $data['model_number'] = 'tested'.$key;
 $collection2->addItem(
 new MagentoFrameworkDataObject($data)
 );
 

 $this->setCollection($collection2);

 return parent::_prepareCollection();

Code create table

 $this->addColumn(
 'model_number',
 [
 'header' => __('Model number'),
 'index' => 'model_number',
 'sortable' => true,
 'type' => 'text',
 'escape' => true,
 'header_css_class' => 'col-value',
 'column_css_class' => 'col-value',
 ]
 );

My code on model/resourceModel collection

namespace MagentoPurchaseWizardModelResourceModelPurchaseList;

use MagentoFrameworkDataCollection as DataCollection;
class EmptyCollection extends DataCollection

magento2 collection

share|improve this question

edited 5 hours ago

Denis Maksiura

asked yesterday

Denis MaksiuraDenis Maksiura

114

$collection = $this->_postFactory->create()->getCollection();

 $collection2 = $this->_purchaseListCollection;

 foreach ($collection->getData() as $key => $data) 
 $data['model_number'] = 'tested'.$key;
 $collection2->addItem(
 new MagentoFrameworkDataObject($data)
 );
 

 $this->setCollection($collection2);

 return parent::_prepareCollection();

 $this->addColumn(
 'model_number',
 [
 'header' => __('Model number'),
 'index' => 'model_number',
 'sortable' => true,
 'type' => 'text',
 'escape' => true,
 'header_css_class' => 'col-value',
 'column_css_class' => 'col-value',
 ]
 );

namespace MagentoPurchaseWizardModelResourceModelPurchaseList;

use MagentoFrameworkDataCollection as DataCollection;
class EmptyCollection extends DataCollection

share|improve this question

edited 5 hours ago

Denis Maksiura

asked yesterday

Denis MaksiuraDenis Maksiura

114

share|improve this question

edited 5 hours ago

Denis Maksiura

asked yesterday

Denis MaksiuraDenis Maksiura

114

asked yesterday

Denis MaksiuraDenis Maksiura

114

asked yesterday

Denis MaksiuraDenis Maksiura

114

1 Answer
1

active

oldest

votes

0

You can filter the collection by addFieldToFilter method

Try this,

$collection = $this->_postFactory->create()->getCollection();
$collection->addFieldToFilter('column_name','value')->addFieldToFilter('column2_name','value');

this will filter your collection by two field and you can add however you want, may be filter by single column or as many as you need.

share|improve this answer

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How to filter data when they are searched?
  
  – Denis Maksiura
  5 hours ago
  

  
  
  
  

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%2f265753%2fhow-to-use-filters-for-new-collection%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can filter the collection by addFieldToFilter method

Try this,

$collection = $this->_postFactory->create()->getCollection();
$collection->addFieldToFilter('column_name','value')->addFieldToFilter('column2_name','value');

this will filter your collection by two field and you can add however you want, may be filter by single column or as many as you need.

share|improve this answer

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How to filter data when they are searched?
  
  – Denis Maksiura
  5 hours ago
  

  
  
  
  

add a comment | 

0

You can filter the collection by addFieldToFilter method

Try this,

$collection = $this->_postFactory->create()->getCollection();
$collection->addFieldToFilter('column_name','value')->addFieldToFilter('column2_name','value');

this will filter your collection by two field and you can add however you want, may be filter by single column or as many as you need.

share|improve this answer

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How to filter data when they are searched?
  
  – Denis Maksiura
  5 hours ago
  

  
  
  
  

add a comment | 

You can filter the collection by addFieldToFilter method

Try this,

$collection = $this->_postFactory->create()->getCollection();
$collection->addFieldToFilter('column_name','value')->addFieldToFilter('column2_name','value');

this will filter your collection by two field and you can add however you want, may be filter by single column or as many as you need.

share|improve this answer

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

$collection = $this->_postFactory->create()->getCollection();
$collection->addFieldToFilter('column_name','value')->addFieldToFilter('column2_name','value');

share|improve this answer

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417

answered 15 hours ago

Prathap GunasekaranPrathap Gunasekaran

1,246417