Ttdfjt

How to tease a romance without a cat and mouse chase?

why "American-born", not "America-born"?

Story about encounter with hostile aliens

Why is there no current between two capacitors connected in series?

Managing heat dissipation in a magic wand

Does the Aboleth have expertise in History and Perception?

Good examples of "two is easy, three is hard" in computational sciences

Filter a file list against an integer array?

pwaS eht tirsf dna tasl setterl fo hace dorw

Way of refund if scammed?

What should I wear to go and sign an employment contract?

Keeping the dodos out of the field

Requirement for splicing neutrals in a switch

How to become an Editorial board member?

How can sister protect herself from impulse purchases with a credit card?

tikz: 5 squares on a row, roman numbered 1 -> 5

Is there any mention of ghosts who live outside the Hogwarts castle?

Parse a C++14 integer literal

How to use Screen Sharing if I don't know the remote Mac's IP address

How can I use 400 ASA film in a Leica IIIf, which does not have options higher than 100?

How could the B-29 bomber back up under its own power?

Do seaplanes need to get clearance for takeoff?

Warped chessboard

How did Jean Parisot de Valette, 49th Grand Master of the Order of Malta, die?

add filter before load data in custom admin grid in magento 2

catalog grid custom filter function is too specificCannot filter new column calculated in custom customer gridMagento 2 - Need a multi-select filter in place of dropdown in admin gridCategory filter in custom admin grid in tab not workingFilter is not working for a boolean datatype column in custom admin gridMagento 2: How to add custom filters in Orders Report?Filter to the magento admin grid column with renderer valueMagento 2 -Admin Grid Select filter with comma separated valuesmagento 1 - How to addClass without JS to the dropdown filter in Admin custom gridadd filter in custom admin grid before load data in magento 2

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

0

Here i have to add filter in charity and fee column,if charity is filled then display in grid otherwise that data should not show in grid.

But all record's are displayed.
I have 2 order in one order charity is applied. I want to display only that order wich charity is applied. please help..

Thank you..

magento2 magento2.3 filter custom-admin-grid

share|improve this question

asked May 14 at 10:57

moni patelmoni patel

13

add a comment | 

0

0

Here i have to add filter in charity and fee column,if charity is filled then display in grid otherwise that data should not show in grid.

But all record's are displayed.
I have 2 order in one order charity is applied. I want to display only that order wich charity is applied. please help..

Thank you..

magento2 magento2.3 filter custom-admin-grid

share|improve this question

asked May 14 at 10:57

moni patelmoni patel

13

add a comment | 

Here i have to add filter in charity and fee column,if charity is filled then display in grid otherwise that data should not show in grid.

But all record's are displayed.
I have 2 order in one order charity is applied. I want to display only that order wich charity is applied. please help..

Thank you..

magento2 magento2.3 filter custom-admin-grid

share|improve this question

asked May 14 at 10:57

moni patelmoni patel

13

share|improve this question

asked May 14 at 10:57

moni patelmoni patel

13

share|improve this question

asked May 14 at 10:57

moni patelmoni patel

13

asked May 14 at 10:57

moni patelmoni patel

13

asked May 14 at 10:57

moni patelmoni patel

13

1 Answer
1

active

oldest

votes

0

Add below code in 'Model/ResourceModel/Grid/Collection' file for filter grid

protected function _renderFiltersBefore()


 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $request = $objectManager->get('MagentoFrameworkAppRequestHttp');
 $filters = $request->getParam("filters");
 if (isset($filters['product_id'])) 
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $product = $objectManager- >get('MagentoCatalogModelProductFactory')->create()
 ->getCollection()
 ->addAttributeToFilter('sku', ['eq'=>$filters['product_id']])->getFirstItem();
 $this->getSelect()->orWhere("product_id = '" . $product->getId() . "'");
 
parent::_renderFiltersBefore(); 

But its not working for me.

share|improve this answer

answered May 14 at 11:03

moni patelmoni patel

13

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%2f274524%2fadd-filter-before-load-data-in-custom-admin-grid-in-magento-2%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Add below code in 'Model/ResourceModel/Grid/Collection' file for filter grid

protected function _renderFiltersBefore()


 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $request = $objectManager->get('MagentoFrameworkAppRequestHttp');
 $filters = $request->getParam("filters");
 if (isset($filters['product_id'])) 
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $product = $objectManager- >get('MagentoCatalogModelProductFactory')->create()
 ->getCollection()
 ->addAttributeToFilter('sku', ['eq'=>$filters['product_id']])->getFirstItem();
 $this->getSelect()->orWhere("product_id = '" . $product->getId() . "'");
 
parent::_renderFiltersBefore(); 

But its not working for me.

share|improve this answer

answered May 14 at 11:03

moni patelmoni patel

13

add a comment | 

0

Add below code in 'Model/ResourceModel/Grid/Collection' file for filter grid

protected function _renderFiltersBefore()


 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $request = $objectManager->get('MagentoFrameworkAppRequestHttp');
 $filters = $request->getParam("filters");
 if (isset($filters['product_id'])) 
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $product = $objectManager- >get('MagentoCatalogModelProductFactory')->create()
 ->getCollection()
 ->addAttributeToFilter('sku', ['eq'=>$filters['product_id']])->getFirstItem();
 $this->getSelect()->orWhere("product_id = '" . $product->getId() . "'");
 
parent::_renderFiltersBefore(); 

But its not working for me.

share|improve this answer

answered May 14 at 11:03

moni patelmoni patel

13

add a comment | 

Add below code in 'Model/ResourceModel/Grid/Collection' file for filter grid

protected function _renderFiltersBefore()


 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $request = $objectManager->get('MagentoFrameworkAppRequestHttp');
 $filters = $request->getParam("filters");
 if (isset($filters['product_id'])) 
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $product = $objectManager- >get('MagentoCatalogModelProductFactory')->create()
 ->getCollection()
 ->addAttributeToFilter('sku', ['eq'=>$filters['product_id']])->getFirstItem();
 $this->getSelect()->orWhere("product_id = '" . $product->getId() . "'");
 
parent::_renderFiltersBefore(); 

But its not working for me.

share|improve this answer

answered May 14 at 11:03

moni patelmoni patel

13

protected function _renderFiltersBefore()


 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $request = $objectManager->get('MagentoFrameworkAppRequestHttp');
 $filters = $request->getParam("filters");
 if (isset($filters['product_id'])) 
 $objectManager = MagentoFrameworkAppObjectManager::getInstance();
 $product = $objectManager- >get('MagentoCatalogModelProductFactory')->create()
 ->getCollection()
 ->addAttributeToFilter('sku', ['eq'=>$filters['product_id']])->getFirstItem();
 $this->getSelect()->orWhere("product_id = '" . $product->getId() . "'");
 
parent::_renderFiltersBefore(); 

share|improve this answer

answered May 14 at 11:03

moni patelmoni patel

13

answered May 14 at 11:03

moni patelmoni patel

13

answered May 14 at 11:03

moni patelmoni patel

13