Good Afternoon,
I am looking at a data scoping issue around category content fields for Magento 2 (2.4.5-p2). I have a list of fields that we typically fill in (please see below for category content field list). I would like to run a check against the category data tables and find out which categories have these fields where scope is not default scope and order the results by “store_id > category > field” if possible. I have done similar scope db before checks for cms blocks / pages but I am struggling with the categories fields.
Field List:
thumbnail
category image
category small image
category mobile image
Description
short description
sub title
additional content
featured block
Any help or guidance with this would be greatly appreciated.