# Filter Operators in Advanced Search

**URL:** <https://pug.phocassoftware.com/t/filter-operators-in-advanced-search/1564>\
**Category:** Product Ideas\
**Created:** [April 16, 2020, 8:48pm UTC](https://pug.phocassoftware.com/t/filter-operators-in-advanced-search/1564 "2020-04-16T20:48:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Mike](https://pug.phocassoftware.com/u/Mike)\
**Post date:** [April 16, 2020, 8:48pm UTC](https://pug.phocassoftware.com/t/filter-operators-in-advanced-search/1564/1 "2020-04-16T20:48:40Z")

</div>

Is it possible to add “Greater Than or Equal To” and “Less Than or Equal To” filter operators in the Advanced Search? I’m trying to build a report for my sales team that looks at customers that have $0 or negative sales in a dynamic, but defined period.

Currently, I have to set up an ‘Or’ statement filtering when sales = $0, and another where sales are less than $0. This works great until I need to filter on (or exclude) a specific property value. Since it’s an ‘Or’ type filter, I have to enter a property filter using ‘Or’ against my existing sales filter and I end up with undesirable results .

 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/9328e59348208123aed10dae2baa3e6bcef08d79.png)  
If I keep just my sales filters in Advanced Search and attempt to exclude the property in grid/table, I’m limited to “Equals ‘XYZ’” or “Like ‘XYZ’”.

Ideally, I would like to have the ability to use both ‘AND’ and ‘OR’ filters in the same Advance Search or be able to manage a filter hierarchy within a report. This probably should be three separate, but related product suggestions. However, having the ability to choose “Less Than or Equal To” on the measure in Advanced Search would solve my roadblock.

Thanks for the consideration

---

<div class="post-metadata">

**Author:** ![wdavis](https://avatars.discourse-cdn.com/v4/letter/w/d07c76/32.png) [@wdavis](https://pug.phocassoftware.com/u/wdavis)\
**Post date:** [April 20, 2020, 2:36pm UTC](https://pug.phocassoftware.com/t/filter-operators-in-advanced-search/1564/2 "2020-04-20T14:36:12Z")

</div>

Not sure if this is a long term solution (or if it even works at all) but why don’t you try 'Less than 1" and that will give you all values at 0 and below.

---

<div class="post-metadata">

**Author:** ![Pablo\_Phocasso](https://avatars.discourse-cdn.com/v4/letter/p/85f322/32.png) [@Pablo\_Phocasso](https://pug.phocassoftware.com/u/Pablo_Phocasso)\
**Post date:** [October 24, 2024, 1:04am UTC](https://pug.phocassoftware.com/t/filter-operators-in-advanced-search/1564/3 "2024-10-24T01:04:46Z")

</div>

I think I have a new solution!

- **Not Blank** : Filter so the property is **Greater Than** the earliest (`0`th) ASCII character, namely the NUL character: [`�`](https://unicode-explorer.com/c/0000).

- **Is Blank** : Filter so the property is **Less Than** the NUL character (`�`).