get category custom attribute value using sql

This query will get robot_index attribute value with list of categories.you can join multiple attribute as per your requirement.
SELECT `c1`.* from catalog_category_entity_varchar AS c1 JOIN catalog_category_entity AS c2 ON c1.row_id = c2.entity_id JOIN eav_attribute AS e ON c1.attribute_id = e.attribute_id WHERE `attribute_code` = 'robot_index' AND `entity_type_id` = '3' AND c2.path LIKE '%1/1830/2355/%'

Comments

Post a Comment

Popular posts from this blog

Magento 2 upgrade steps

Step 1: Enable Maintenance Mode  php bin/magento maintenance:enable  Step 2 : Composer Backup:  Run the following command cp composer.json composer.json.bak  Step 3 : Run this command composer require-commerce magento/product-community-edition 2.4.6-p1 --no-update  Step 4 : composer clear-cache && composer update  Step 5: Magento Schema and Data Update: Run the following commands: sudo php bin/magento setup:upgrade sudo php bin/magento setup:di:compile  Step 6: Disable Maintenance Mode php bin/magento maintenance:disable
Read more

Magento 2 test data clean using my sql query

Before runing this query please take your database backup.You may face too many redirect issue in category admin view. So that error please check any third party module is using the category data or not for ex.. mageplaza seo, amasty xsearch this type of module may cause some issue in category view page. Delete all customers at once. SET FOREIGN_KEY_CHECKS=0; -- Customers TRUNCATE TABLE `customer_address_entity`; TRUNCATE TABLE `customer_address_entity_datetime`; TRUNCATE TABLE `customer_address_entity_decimal`; TRUNCATE TABLE `customer_address_entity_int`; TRUNCATE TABLE `customer_address_entity_text`; TRUNCATE TABLE `customer_address_entity_varchar`; TRUNCATE TABLE `customer_entity`; TRUNCATE TABLE `customer_entity_datetime`; TRUNCATE TABLE `customer_entity_decimal`; TRUNCATE TABLE `customer_entity_int`; TRUNCATE TABLE `customer_entity_text`; TRUNCATE TABLE `customer_entity_varchar`; TRUNCATE TABLE `customer_grid_flat`; TRUNCATE TABLE `customer_log`; TRUNCATE TABL...
Read more

Magento 2 invalid Form key

There is also in Magento 2 a form key validator Magento \Framework\Data\Form\FormKey\Validator public function validate(\Magento\Framework\App\RequestInterface $request) { $formKey = $request->getParam('form_key', null); if (!$formKey || $formKey !== $this->_formKey->getFormKey()) { return false;//for solving please return true here } return true; }
Read more