{"data":{"id":"ACSD-66311","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where the Companies grid loads slowly for admin users with restricted websites access.","categories":["B2B"],"components":["magento/module-company"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-66311-companies-grid-loads-slowly-for-restricted-admins","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-66311-companies-grid-loads-slowly-for-restricted-admins.md","blobSha":"69d269f5550f47e223eaee5ec8c3923ca092abbb","description":"Companies grid loads slowly for admin users with restricted website access.","stepsToReproduce":"1. Install Adobe Commerce with B2B features. 1. Create 2 extra websites (in addition to Main website) with stores/views: * Main Website (created during installation) * Website 2 → Store 2 → StoreView 2 * Website 3 → Store 3 → StoreView 3 1. Create the Admins in Scope user role: * Scope: only two stores: Main Website + Website 3/Store 3. * Resources: only Dashboard + Companies. 1. Create an admin user with a role Admins in Scope, for example, adminscope. 1. Generate specific distributed customer and company data: 1. Customers assigned to websites | Website ID | Number of customers | |------------|---------------------| | 1 | 600,000 | | 2 | 1,500 | | 3 | 500 | 1. Run the following query to verify the distribution: SELECT website_id, COUNT(*) FROM customer_entity GROUP BY website_id; 1. Customers assigned to companies | Number of customers | Number of companies | |---------------------|---------------------| | 1 | 4,500 | | 2 | ~1,000 | | ~595k | 1 | 1. Run the following query to verify the distribution: SELECT customer_count, COUNT(*) AS number_of_companies FROM ( SELECT company_id, COUNT(customer_id) AS customer_count FROM company_advanced_customer_entity GROUP BY company_id ) AS subquery GROUP BY customer_count ORDER BY customer_count; 1. Reindex all data to generate entries in the customer_grid_flat. 1. Log in as adminscope. 1. Go to Customers > Companies.","introducedInQpt":"1.1.69","createdFor":["2.4.7-p4"],"documentedRange":"2.4.7-p4 - 2.4.8-p1","scheduledFixRelease":"2.4.9"},"files":[{"package":"magento/magento2-b2b-base","constraint":">=1.5.1 <1.5.3","path":"patches/commerce/ACSD-66311_1.5.1.patch","blobSha":"15845092620e462ffd4b162e685ecfc2dd3bae68","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-66311_1.5.1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-company/Model/ResourceModel/Company/Collection.php","change":"modified","package":"magento/module-company"},{"path":"vendor/magento/module-company/Plugin/Company/CollectionFilter.php","change":"modified","package":"magento/module-company"}],"packages":["magento/module-company"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.8-p4","2.4.8-p3","2.4.8-p2","2.4.8-p1","2.4.8","2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-66311 details"}