cancel
Showing results for 
Search instead for 
Did you mean: 

MGS Front End builder extension Find Enabled Users

SOLVED

MGS Front End builder extension Find Enabled Users

Hello,

is there a way to find all users that font-end builder is enabled?

Regards,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: MGS Front End builder extension Find Enabled Users

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution ! Smiley Happy

View solution in original post

3 REPLIES 3

Re: MGS Front End builder extension Find Enabled Users

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution ! Smiley Happy

Re: MGS Front End builder extension Find Enabled Users

 How to use Brand extension in Claue theme on the magento2 ToysRUs Credit Card

Re: MGS Front End builder extension Find Enabled Users

Thank you this was really helpful!!!