# Smart list condition not working

**URL:** <https://forum.litium.com/t/smart-list-condition-not-working/1352>\
**Category:** Questions\
**Tags:** litium-7\
**Created:** [February 25, 2020, 10:09am UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352 "2020-02-25T10:09:08Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Artur](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/artur/32/948_2.png) [@Artur](https://forum.litium.com/u/Artur)\
**Post date:** [February 25, 2020, 10:09am UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/1 "2020-02-25T10:09:08Z")

</div>

Hi,

We are trying to do smart list with some conditions to export products.  
However when we add couple of conditions it seems to ignore our decimal condition fully.

For example i even can do  
Less than 14, Greater than 14, it somehow filters some but i still get products with the value 10, 13, 15 etc on the exact same field i just filtered on.

Litium version: 7.2.3

---

<div class="post-metadata">

**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\
**Post date:** [February 25, 2020, 6:38pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/2 "2020-02-25T18:38:12Z")

</div>

You get hits on your smart product list with the incorrect values using that filter? Since both conditions has to be true, you should get no hits since the value can’t be both less than 14 and greater than 14.

But if instead you mean that when you use only one of the conditions, you get additional products in the export. That could be because the export always exports the base product and all its variants.

---

<div class="post-metadata">

**Author:** ![Artur](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/artur/32/948_2.png) [@Artur](https://forum.litium.com/u/Artur)\
**Post date:** [February 25, 2020, 6:43pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/3 "2020-02-25T18:43:46Z")

</div>

I get a hit with them both set.  
And also get products in smartlist with values that should not be there when only one of of them is set.

Reason for this is that we want to do a smartlist with a specific rule and then export only variants based on that rule. But you are saying this is impossible with this?

---

<div class="post-metadata">

**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\
**Post date:** [February 25, 2020, 9:11pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/4 "2020-02-25T21:11:48Z")

</div>

Can you make a screenshot of the conditions that you have added to your filter? Think it is easier to understand what you try to achieve.

---

<div class="post-metadata">

**Author:** ![Artur](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/artur/32/948_2.png) [@Artur](https://forum.litium.com/u/Artur)\
**Post date:** [February 26, 2020, 12:57pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/5 "2020-02-26T12:57:09Z")

</div>

Impossible filter “fälgdiameter” is decimal

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/865be57d5c414696f48bf7e224bca30ecbcb5628.png)

If i set only one condition on it eg: \<=14 i get items that are bigger.

---

<div class="post-metadata">

**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\
**Post date:** [February 26, 2020, 1:52pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/6 "2020-02-26T13:52:51Z")

</div>

You have an **and** between the condition so what you tell the system that you want all with _Fälgdiameter less than 14_ **and** _Fälgdiameter greater than 14_. The reson that result may get hits in the search result is that the search will be like _give me all base products where any of the variant will match the condition_ then you can have a base product with two variants that each of the variant will match the condition.

Can you invert your condition? _Give my all products where not Fälgdiameter not equal 14._

---

<div class="post-metadata">

**Author:** ![Artur](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/artur/32/948_2.png) [@Artur](https://forum.litium.com/u/Artur)\
**Post date:** [February 26, 2020, 5:02pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/7 "2020-02-26T17:02:58Z")

</div>

**So for the use-case;**  
A base product and Variants B, C, D

You filter (x \<= B) =\> you will get A and B,C,D  
You filter (x \< B and x \> C) =\> you will get A and B,C,D  
You filter (x \> B and x \< D) =\> you will get A and B,C,D

**So to summary (If i understand it correctly):**  
You can do AND on product level; however since it matches any of the variants of said base product it returns that base product and its variants meaning OR on variant level.

I have created the ideas since this feels like a feature request then?  
[https://ideas.litium.com/ideas/L-I-99](https://ideas.litium.com/ideas/L-I-99)  
[https://ideas.litium.com/ideas/L-I-100](https://ideas.litium.com/ideas/L-I-100)

---

<div class="post-metadata">

**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\
**Post date:** [February 26, 2020, 5:53pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/8 "2020-02-26T17:53:03Z")

</div>

Yes, for the search result it is as you describe.

In Litium 7.4 we introduced views to view from the variant view instead of the base product.

When the engine for the smart product list the variant including base product (variant OR base product) that matching the conditions will be selected and added to the smart list.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/12eddac3b8b661de1db86af10ac8151b571e6fb9.png) [@system](https://forum.litium.com/u/system)\
**Post date:** [March 25, 2020, 5:53pm UTC](https://forum.litium.com/t/smart-list-condition-not-working/1352/9 "2020-03-25T17:53:06Z")

</div>

Closed on March 25, 2020, 5:53pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
