Tag: company

I want to display B2B company name in customer grid while we create sales order from admin. For temporary changes I added my code in below class

MagentoSalesModelResourceModelOrderCustomerCollection 

Please check my added code in below function

protected function _initSelect()
    {
        parent::_initSelect();
        $this->addNameToSelect()->addAttributeToSelect(
            'email'
        )->addAttributeToSelect(
            'created_at'
        )->joinAttribute(
            'billing_postcode',
            'customer_address/postcode',
            'default_billing',
            null,
            'left'
        )->joinField(
            'store_name',
            'store',
            'name',
            'store_id=store_id',
            null,
            'left'
        );
        /**Custom added code**/
        $tableName = 'company';
        $this->getSelect()->joinLeft(
                $tableName,
                $tableName . '.super_user_id = e.entity_id',
                $tableName . '.company_name'
            );
        
        return $this;
    }

And after adding this I am able to display Company name in grid check attached screenshot

but while I am trying to filter company name I am getting below error.

Exception #0 (MagentoFrameworkExceptionLocalizedException): The
“company_name” attribute name is invalid. Reset the name and try
again.

Exception #0 (MagentoFrameworkExceptionLocalizedException): The
“company_name” attribute name is invalid. Reset the name and try
again. #1
MagentoEavModelEntityCollectionAbstractCollection->_getAttributeConditionSql(‘company_name’,
array(‘like’ => &Zend_Db_Expr#000000002083056200000000795ea168#),
‘left’) called at
(vendormagentomodule-eavModelEntityCollectionAbstractCollection.php:380)

Please suggest that how can I filter company name