Skip to main content
2 of 2
added 24 characters in body; edited title
Attila Naghi
  • 4.1k
  • 4
  • 40
  • 76

How do I get the attributes using a group id?

I want to generate a query, which returns me all of the attributes from a specific group. In the image below you can see the wanted result:D enter image description here

This is my try:

select ea.attribute_code from eav_attribute ea
inner join eav_entity_attribute eav
on ea.entity_type_id = eav.entity_type_id
inner join eav_entity_type t
on ea.entity_type_id = t.entity_type_id
where eav.attribute_group_id = 26 
and t.entity_type_code = 'catalog_product'

26 is the General id.

What should i change with my query ?

Attila Naghi
  • 4.1k
  • 4
  • 40
  • 76