Filter by Enabled / Disabled?

[zoran_zulumovsk]

Hi,

I've made a query that gives me a list of products with som attributes. I'd like to get this filtered to show only product that are enabled. How do i do that?

my code so far:

SELECT
updated_at AS "time",
Sku AS "Sku",
name AS "Product",
price AS "Price",
cost AS "Cost"
FROM catalog_product_flat_2
WHERE
$__timeFilter(updated_at)
ORDER BY updated_at

[namitapare2a78]

Hello @zoran_zulumovsk,

Greeting!

You just need to add one thing in the query as follows.  

SELECT
updated_at AS "time",
Sku AS "Sku",
name AS "Product",
price AS "Price",
cost AS "Cost"
FROM catalog_product_flat_2
WHERE
($__timeFilter(updated_at) AND isEnabled='1' )
ORDER BY updated_at

Hope this will help you!

If not, feel free to contact us.

Solved?

Click KUDOS and accept it as a solution.

Thank you!