media attribute in product flat data

[speerio]

Hello,

I have added an extra media attribute in magento (1.8.1) an need this attribute in the  product flat data table.

( the  option "use in product listing" is not available on this type)

I found some answers on the internet but none of them worked.

How can i get a media attribute into the product flat data?

[speerio · Accepted solution]

OK, solved the issue my self. Just set the value "used in product listing" to 1 directly in the database.

Re-index en cleared the cache and everything works as hoped.