hi i want search products by empty feature on admin, for eg: my brand feature id 1
i want list products with empty brand feature i try following code but it doesnt work.
any can check ?
in get_products hooks
$join .= db_quote(" LEFT JOIN ?:product_features_values ON ?:product_features_values.product_id = products.product_id AND ?:product_features_values.lang_code = ?s", $lang_code); $condition .= db_quote(" AND NOT ?:product_features_values.feature_id = ?i", '1');