Jump to content

[solved] Which table contains Colour Picker field?


noesac
 Share

Recommended Posts

I'm trying to write a query that displays all products with combinations > 0, but does not have a Colour Picker = TRUE

 

 

But I can't seem to find where this value is stored. It makes sense that it should be in ps_product but it's not. Does anyone have any idea?

Share this post


Link to post
Share on other sites

I just wrote the following query in case anyone wants to use it in the future:

 

 

SELECT ps_product_lang.name, ps_product.id_product AS id

FROM ps_product

LEFT JOIN ps_product_attribute ON

ps_product.id_product = ps_product_attribute.id_product

INNER JOIN ps_product_lang ON

ps_product_lang.id_product = ps_product.id_product

WHERE ps_product.active = 1 AND ps_product.id_color_default = 0

GROUP BY ps_product.id_product

HAVING COUNT(ps_product.id_product) > 1

Edited by noesac (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites

manu thans for your SQL query - im convinced that it will be really helpful for other community members

 

now i can mark this thread as [solved]

 

feel free to continue discussion here

 

regards!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More