# Boolean "OR" broken?

**URL:** https://discuss.tryton.org/t/boolean-or-broken/5149
**Category:** User
**Created:** [March 31, 2022, 11:09am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149 "2022-03-31T11:09:40Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [March 31, 2022, 11:09am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/1 "2022-03-31T11:09:40Z")

</div>

I learned that I can search for  
`Article contains string xxx` OR `Article contains string yyy` by  
`Article: xxx; yyy` - separated with semicolon.

Now I get a result with search for “SKR” in a warehouse - the whole list with “SKR100x24” “SKR90x24” etc. And I get results for all the “SB” items.  
But when doing a `Artikel: SKR; SB` search, the list is empty.

My fault - or a bug?

Greetings,  
Wolf

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [March 31, 2022, 11:49am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/2 "2022-03-31T11:49:48Z")

</div>

This form correspond to a `in` operator so it will find only product with the exact name ‘SKR’ or ‘SB’.

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [March 31, 2022, 1:15pm UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/3 "2022-03-31T13:15:23Z")

</div>

Arrrgh. Understood.

I grouped my articles by key phrases and measures, such as “SKR80x20” or “SKR64x24”; or “SB40x6” and “SB33x6”. Is threre another way to create a list of all “SKR” and all “SB” items at a time?

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [April 1, 2022, 8:01am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/4 "2022-04-01T08:01:28Z")

</div>

> [@herrdeh](#):
>
> Is threre another way to create a list of all “SKR” and all “SB” items at a time?

`Article: xxx or Article: yyy`

This will produce a OR domain testing both conditions

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [April 1, 2022, 8:55am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/5 "2022-04-01T08:55:37Z")

</div>

Thank you very much - this helps a lot.  
Nevertheless, I need to say that the present behaviour is really confusing, counter-intuitive and frustrating.

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [April 5, 2022, 5:46am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/6 "2022-04-05T05:46:09Z")

</div>

My suggestion in general on this is to improve the search dialogue to have a more intuitive approach. Evolution PIM has got this dialogue to create mail filters, which may give some inspiration:

 ![Bildschirmfoto von 2022-04-05 07-39-11](https://discuss-cdn.tryton.org/uploads/default/original/2X/4/4786c841be1a70ffabfa00876b780b23a33951a2.png)

We could have a pop up selector for type of search criteria, a type in box for the search string, a “add more” button, a selector for the type of boolean - etc.  
And finally a check box “save search” with a text box.

When exploring improvement of the search feature, please remember that at present (v6.0), AFAIK there is no search feature at all at general ledger, loss&earnings (and maybe some other of this type I’m not aware of.

Cheers,  
Wolf

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [May 5, 2022, 5:46am UTC](https://discuss.tryton.org/t/boolean-or-broken/5149/7 "2022-05-05T05:46:23Z")

</div>

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