How to filter customer by custom attribute using SQL query?

Question

The zd_user_id is our customer custom attribute.

$customerCollection = $this->customerFactory->create();
$customers = $customerCollection->addAttributeToFilter(
    [
        ['attribute' => 'zd_user_id', 'null' => true],
        ['attribute' => 'zd_user_id', 'eq' => ''],
        ['attribute' => 'zd_user_id', 'eq' => 'NO FIELD']
    ],
    '',
    'left'
)

How could I get all customers with the attribute zd_user_id equal true via SQL?

Rafael Corrêa Gomes · Accepted Answer · 2020-10-27 21:16:28Z

2

select * from eav_attribute where attribute_code='zd_user_id';

from this query, you get the attribute id and you also get the backend_type for this attribute.

Assuming the backend type is int.

select count(*) from customer_entity_int where attribute_id=<attribute_id_found> and value=1;

If it's varchar you can change the query to search in the table customer_entity_varchar.

edited Oct 27, 2020 at 21:16

Rafael Corrêa Gomes

14k15 gold badges93 silver badges192 bronze badges

answered Oct 27, 2020 at 20:22

Herve Tribouilloy

7,7962 gold badges15 silver badges29 bronze badges

Add a comment |

Stack Exchange Network

How to filter customer by custom attribute using SQL query?

1 Answer 1

Your Answer

Hot Network Questions

How to filter customer by custom attribute using SQL query?

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions