---
title: "Search Operators"
description: "Use search operators in Juan to quickly find specific records by filtering results with simple, flexible search rules."
url: https://help.juan.ac/en/articles/9994191-search-operators
collection: "Navigating Juan"
updated: 2026-08-27
language: en
---

# Search Operators

Use search operators in Juan to quickly find specific records by filtering results with simple, flexible search rules.

## Q1. What are search operators?

-   Search operators help you quickly find specific records in Juan by refining your search parameters. 
    
-   These are the commonly used operators:
    

<table data-id="0eff09dd-dd55-4f59-9bb4-6e16f67075ad" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="2" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="577902dd-bf89-45a5-9fbd-8ab22d1b2a72"><span style="color: #000000;"><strong>AMOUNTS</strong></span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="d634e10d-1937-4021-b47c-8f03b4c817d1"><span style="color: #000000;">Exact</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="a7f4f58c-44af-4a6b-8fa3-0c4e8a2f53c0"><span style="color: #535353;">₱500 | </span><span style="color: #12181f;">PHP</span><span style="color: #535353;">500</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="ea7c269a-403d-4f9c-941f-574b73a86c4a"><span style="color: #000000;">Range</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="dd25c99b-c9ed-419a-8282-4401d8d7119c"><span style="color: #12181f;">PHP</span><span style="color: #535353;">100-500 | </span><span style="color: #12181f;">PHP</span><span style="color: #535353;">100 to </span><span style="color: #12181f;">PHP</span><span style="color: #535353;">500</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="09b2908e-49a2-4bd6-9f8c-3efbe6e771d2"><span style="color: #000000;">Min/Max</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="69cfd29e-df15-4ca8-a0c6-3bfa1280ab1b"><span style="color: #000000;">PHP500+ | PHP&lt;200 to $&gt;=1000</span></p></td></tr><tr><td colspan="2" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="3f11fc65-8c11-4aab-bea1-d38afa61a2ec"><span style="color: #000000;"><strong>DATES</strong></span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="2dfcc67f-ce44-40ff-942d-30682d19dd1f"><span style="color: #000000;">Relative</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="e6d0a6ee-ea9c-4296-9f8d-d4a21cb15171"><span style="color: #12181f;">date:</span><span style="color: #535353;">today | </span><span style="color: #12181f;">date:</span><span style="color: #535353;">this month | </span><span style="color: #12181f;">date:</span><span style="color: #535353;">last quarter</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="f92c4f01-179b-4b27-a685-e0a096bfa370"><span style="color: #000000;">Range</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="17c83845-7afd-4ba1-b561-895083573acd"><span style="color: #12181f;">date:</span><span style="color: #535353;">jan-mar 2026 | </span><span style="color: #12181f;">date:</span><span style="color: #535353;">-30d</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="9ac516f7-96de-44a2-b6e8-ada45b855f06"><span style="color: #000000;">Due</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="e73ba3df-d700-463d-ba67-7f506fe2b40c"><span style="color: #000000;">due:today | due:&gt;2025-06-01</span></p></td></tr><tr><td colspan="2" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="71ead549-af00-42f6-9601-d2e4fe6eec02"><span style="color: #000000;"><strong>FIELDS</strong></span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="6d2e0edb-3e51-426d-8fd6-7dca19daa611"><span style="color: #000000;">Status</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="37417c20-f25d-4eb1-a86a-8c21edafe91e"><span style="color: #000000;">status:paid | status:overdue | status:paid,void</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="491433ed-4707-4c79-83e6-8b12c1a675a0"><span style="color: #000000;">Contact</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="f74dfecd-242b-4b0b-bc1f-83091a76ae6f"><span style="color: #000000;">customer:bravo | supplier:acme</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="2b131ebc-d8ee-4cc9-85da-11cb90890a84"><span style="color: #000000;">More</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="dde2c1c2-44e4-4d1b-8eca-a6262e887880"><span style="color: #000000;">currency:PHP | tag:priority | ref:INV-2026 | ref:INV-*</span></p></td></tr><tr><td colspan="2" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="ee7dbd54-e845-4978-9046-6ccd77f5d931"><span style="color: #000000;"><strong>ADVANCED</strong></span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="6e7c5922-2464-4915-8ac3-8444d8dcb678"><span style="color: #000000;">Search Help</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="d31f059f-61fd-4e69-824e-ba5b28f723e2"><span style="color: #000000;">help:operators | ?:operators</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="b7ba9f86-f511-4c5b-93f4-03383ecfdb09"><span style="color: #000000;">All Match</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="2a6b7127-31d7-40b1-846f-68304b3157b4"><span style="color: #000000;">status:overdue PHP500+ | status:unpaid AND supplier:acme</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="2d28d34a-d264-403c-aeec-c4b5ae3d27a7"><span style="color: #000000;">Any Match</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="343045a4-a32a-4a26-b516-1dc8c544f83d"><span style="color: #000000;">status:paid OR status:void</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="c843fa98-f23f-4de5-abc0-09c6d4e037ee"><span style="color: #000000;">Exclude</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="04d1a636-89f2-4b72-ad05-e6296f22681e"><span style="color: #000000;">NOT status:paid</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="8cf150a7-031d-4bd7-a212-b6a38e634918"><span style="color: #000000;">Sort By</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="220ae781-353e-48d4-bb81-09bd4fc3fad4"><span style="color: #000000;">sort:amount:desc | sort:date:asc</span></p></td></tr><tr><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="3b475009-9912-40fe-bdbd-c43b9adc1da8"><span style="color: #000000;">Combine</span></p></td><td colspan="1" rowspan="1" style="vertical-align: top; padding: 5pt; overflow: hidden; overflow-wrap: break-word; border-width: 1pt; border-style: solid; border-color: #000000;"><p data-id="5931d62b-a525-48f0-958c-7b76163732cf"><span style="color: #000000;">(status:paid OR status:overdue) PHP500+ NOT customer:bravo</span></p></td></tr></tbody></table>

## Q2. Where does the search operator apply to?

-   Search operators can be used in all Juan features with a search bar in it such as business transactions, journals, bank records, and more.
    

## Q3. How do I use search operators?

-   Type operators directly into the search bar or click the operator icon.
    
-   The basic format is as follows: <operator>:<keywords>
    
    -   Example: contact:fruit planet
        
    -   Note: **there should be no space before and after the colon “:”**
        
-   Note: the easiest way to use it is by typing “**?:**” which will open all the possible operators in the feature you are currently in.
    

![](https://staticfiles.gleap.io/gattachments/tXsjrY6TqRzQrPpEEAZsBtljPNZrf0WjKpweRNzlRpg44GWCwKU14CyM5aAvuGAIWo3N7rrJsIO.png)

![](https://staticfiles.gleap.io/gattachments/XfXVASvBclqb9X3zLoMeI6TsdDDcw1QFL0djNf8IoZ2c5DjACow5FMi0pfZO4uuVLQ5SbOkbFXM.png)

## Q4. How do I combine search operators?

-   To combine different operators, you can use the following combine functions:
    
    -   AND: Shows results that match both conditions
        
        -   Example: “amount:PHP500+ AND contact:Fruit” — will show results that has an amount of 500+ with contacts that has the keyword Fruit
            
    -   OR: Shows results that match either condition
        
        -   Example: “contact:Fruit OR contact:Pacific” — will show results that has either of the two.
            
    -   NOT: Excludes results that match a condition
        
        -   Example “amount:PHP500+ NOT customer:Fruit” — will show results of amounts of 500+ of contacts that don’t have “fruit” in their name.
            

![](https://staticfiles.gleap.io/gattachments/WjS5gc16ViQy3jiCU8ETsckrUYbYdhBG7W9oXlHF3FihyaGSylVLieyEsNZFnAjVLEe06V5GKGY.png)

## Q5. Is there a limit to the number of combinations I can do?

-   There is no limit to how many operators you can combine.
    

## Q6. How do I know if a search operator is invalid?

-   The key term input will be highlighted in red if the entry is invalid. 
    

![](https://staticfiles.gleap.io/gattachments/FKM2oH7lbzqYSoTKEXN1BSZvr4Lwd66SvBiSmV2HqabCFczgzafasnIGhTAGgABpvm2xUwJ6Gmj.png)

## Q7. Are search operators case sensitive?

-   Search operators and keywords are not case sensitive.
