Hello,
is there a way to find all users that font-end builder is enabled?
Regards,
Solved! Go to Solution.
Hello @geokat
Run below query :
SELECT * FROM DB.eav_attribute where attribute_code = "is_fbuilder_account";
here you will get attribute_id, get the attribute id, for ex: 160
and run below query :
SELECT * FROM DB.customer_entity_int where attribute_id = 160 and value = 1;
here value = 1 means who has access.
now you have custom_id who has access, get all the ID's and run below query :
SELECT * FROM DB.customer_grid_flat where entity_id IN (1734,1749,1953,1818,1962);
(1734,1749,1953,1818,1962) these are the ID which I got from second query.
Hope it helps !
Hello @geokat
Run below query :
SELECT * FROM DB.eav_attribute where attribute_code = "is_fbuilder_account";
here you will get attribute_id, get the attribute id, for ex: 160
and run below query :
SELECT * FROM DB.customer_entity_int where attribute_id = 160 and value = 1;
here value = 1 means who has access.
now you have custom_id who has access, get all the ID's and run below query :
SELECT * FROM DB.customer_grid_flat where entity_id IN (1734,1749,1953,1818,1962);
(1734,1749,1953,1818,1962) these are the ID which I got from second query.
Hope it helps !
How to use Brand extension in Claue theme on the magento2 ToysRUs Credit Card
Thank you this was really helpful!!!