main_table prefix on exception company_name

[DavaGordon]

[m2-assistant]

Hi @DavaGordon. Thank you for your report.
To help us process this issue please make sure that you provided the following information:

• Summary of the issue
• Information on your environment
• Steps to reproduce
• Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento give me 2.4-develop instance - upcoming 2.4.x release

For more details, please, review the Magento Contributor Assistant documentation.

Please, add a comment to assign the issue: @magento I am working on this

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

⚠️ According to the Magento Contribution requirements, all issues must go through the Community Contributions Triage process. Community Contributions Triage is a public meeting.

🕙 You can find the schedule on the Magento Community Calendar page.

📞 The triage of issues happens in the queue order. If you want to speed up the delivery of your contribution, please join the Community Contributions Triage session to discuss the appropriate ticket.

🎥 You can find the recording of the previous Community Contributions Triage on the Magento Youtube Channel

✏️ Feel free to post questions/proposals/feedback related to the Community Contributions Triage process to the corresponding Slack Channel

[gabrieldagama]

Hi @DavaGordon, I couldn't reproduce this issue on 2.4, can you confirm the steps and how to reproduce such problem?

Thanks.

[DavaGordon]

Magneto 2 EE (2.3.6) / B2B Module / Magneto Cloud

Steps
Admin Login > Customers

Filter by company name issue occurred reason for this is the reference of company name was coming from the company table which was not in the main table so when we filtered by company we received this issue. this was tested across 3 seperate websites all using similar environment specs and with all none standard magento modules disabled.

Outcome
Unable to filter by company name. after some investigation i found that the original code

if (is_string($field) && count(explode('.', $field)) === 1) {

Always returned true as a result the it returning true the prefix of main_table was added to company_name which if you look at the overall code did no exist in the customer_grid_flat table as we had the company module active so the code should have returned false and retrieved the value from the

company.company_name rather than customer_grid_flat(main_table).company_name

The code below which was put in place on all 3 environments checks the main_table index to check if the column is valid if returns true it will append the main_table prefix otherwise the reference will look in the correct place which is the company table

if (is_string($field) && in_array($field, $this->getFulltextIndexColumns())) {

Tested 3 environments no link in code base 3 seperate companies all same issue. fix resolves issue for all 3

[danieluniform]

This bug occurs in Magento 2.3.7-pt2 as well. Default Magento does not have Company fields setup but once customers are linked to companies, I believe it's not hard to reproduce this error.

[danieluniform]

Solved this on our platform with a before plugin.

/**
     * Fix Magento 2.3.7 problem of not being able to locate the company_name field.
     *
     * @param \Magento\Customer\Model\ResourceModel\Grid\Collection $subject
     * @param $field
     * @param $condition
     * @return array
     */
    public function beforeAddFieldToFilter(\Magento\Customer\Model\ResourceModel\Grid\Collection $subject, $field, $condition) {
        if (strpos($field, 'company_name') !== false ) {
            $field = 'company.company_name';
        }
        return [$field, $condition];
    }

[danieluniform]

It's not really necessary to reproduce this ticket in order to see that this problem exists.

The list of columns in customer_grid_flat is : ["name","email","created_in","taxvat","shipping_full","billing_full","billing_firstname","billing_lastname","billing_telephone","billing_postcode","billing_region","billing_city","billing_fax","billing_company"]

By default, company_name (as in the search fields) is not in customer_grid_flat. Thus, filtering by "company" breaks as it's not a part of the customer index. This should probably be fixed by someone on the team.