1. Home
  2. General Features
  3. Search Modifiers, Boolean Operators and Searchable Fields

Search Modifiers, Boolean Operators and Searchable Fields

Search Modifiers

Using modifiers in your Hiveage searches will help you to narrow your search providing a more accurate search result. We have introduced three new types of modifiers to make your searching more convenient.

  1. Text Modifier
  2. Amount Modifier
  3. Date Modifier

1. Text Modifier

A text modifier allows you to search a specific field. This will populate more accurate search results, compared to the Basic Search.

How to use it

[Textl Modifier]:[Search Term]

E.g.:

  • When you type status:viewed in the Invoices tab, all the invoices with the label ‘viewed’ will be matched.
  • When you type client.name:Adam in the Estimates tab, all the estimates for clients with the name ‘Adam’ will be matched.
  • When you type country:Australia in the Network tab, all businesses from Australia will be matched.

* A full list of text modifiers which can be used in each section is available towards the end of this article.

2. Amount Modifier

Amount modifiers are used with more and less

How to use it

[Amount Modifier]:[Search Term]

E.g.:

  • amount:100 – Match amounts which are exactly 100
  • item.quantity_less:350 – Match item quantities which are less than 350
  • payment.amount_more:2500 – Match payment amounts which are higher than 2500

Both more and less terms support decimal places as well.

The main amount field of an object can be searched by using less and more to simplify usability.

E.g.:

  • less:1000 – Match amounts which are less than 1000
  • more:5000 – Match amounts which are higher than 5000

* A full list of text modifiers which can be used in each section is available towards the end of this article.

3. Date Modifier

Date modifiers are used with on, during, after and before

How to use it

[Date Modifier]:[Search Term]

E.g.:

  • due_on:2016-05-26 – Match items which are due for 2016-05-26
  • date_after:2016-03-01 – Match items after 2016-03-01
  • payment.before:2016-02-28 – Match payments done before 2016-02-28
  • created_during:2016-05-10 – Match items created on 2016-05-10

on and during can be used interchangeably.

E.g.: payment.on:2016-08-10 and payment.during:2016-08-10 will give you same set of results.

The main date field of an object can be searched by using on,during, after and before, to simplify usability.

E.g.:

  • on:2016-04-14 – Match items for 2016-04-14
  • after:2016-04-14 – Match items after 2016-04-14
  • during:2016-04-14 – Match items for 2016-04-14
  • before:2016-04-14 – Match items before 2016-04-14

* A full list of text modifiers which can be used in each section is available towards the end of this article.

Using Boolean Operators

Boolean operators allow terms to be combined through logic operators. Hiveage uses AND, OR and NOT as Boolean operators.

Boolean operators must be ALL CAPS.

E.g.:

  • client.name:john doe AND payment.amount_more:2500 – Search items that contain the name ‘John Doe’ and payment amount more than 2500
  • client.name:john doe OR payment.amount_more:2500 – Search items that contain either the name ‘John Doe’ or payment amount more than 2500
  • client.name:john doe NOT payment.amount_more:2500 – Search items that contain the name ‘John Doe’ but no payment amount more than 2500

To make search more simple, Hiveage allows you to use && (ampersand) for the AND operator, || (vertical bar) for the OR operator and ! (exclamation) for the NOT operator.

E.g.:

  • amount:100 AND client:john joe and amount:100 && client:john joe will give you same results
  • amount:100 OR client:john joe and amount:100 || client:john joe will give you same results
  • amount:100 NOT client:john joe and amount:100 ! client:john joe will give you same results

Using Boolean operators with dates

Using before and after, coupled with a Boolean operator, you can now search for a set of results within a specific period of time.

E.g.:

after:2015-06-25 AND before:2016-03-10

payment.before:2016-09-15 AND payment.after:2016-04-30

Searchable Fields

A full list of searchable fields and search modifiers for each section is below:

1. Invoices

Basic Search Fields

  • id
  • no
  • po_no
  • summary
  • note
  • currency
  • date
  • status
  • payment_methods
  • amount
  • client.email
  • client.name
  • client.contact
  • item.description
  • time.description
  • expense.description
  • mileage.description
  • tag.name
  • tax.name
  • discount.name
  • shipping.name
  • payment.status

Text Modifiers

  • id
  • no
  • po_no
  • summary
  • note
  • currency
  • date
  • status
  • payment_methods
  • client
  • client.email
  • client.name
  • client.contact
  • item
  • item.description
  • time
  • time.description
  • expense
  • expense.description
  • mileage
  • mileage.description
  • tag.name
  • tax.name
  • discount.name
  • shipping.name
  • payment
  • payment.status
  • payment.receipt_no
  • payment.payment_method
  • payment.details

Amount Modifiers

Note: (X)= less, more

  • amount_(X) – Main amount field
  • due_(X)
  • item.quantity_(X)
  • item.rate_(X)
  • item.amount_(X)
  • time.quantity_(X)
  • time.rate_(X)
  • time.amount_(X)
  • expense.amount_(X)
  • mileage.quantity_(X)
  • mileage.rate_(X)
  • mileage.amount_(X)
  • payment.amount_(X)

Date Modifiers

Note: (X)= on, after, before, during

  • date_(X) – Main date field
  • due_(X)
  • payment.(X)
  • created_(X)

2. Estimates

Basic Search Fields

  • id
  • no
  • po_no
  • summary
  • note
  • currency
  • date
  • status
  • payment_methods
  • amount
  • client.email
  • client.name
  • client.contact
  • item.description
  • time.description
  • expense.description
  • mileage.description
  • tag.name
  • tax.name
  • discount.name
  • shipping.name

Text Modifiers

  • id
  • no
  • po_no
  • summary
  • note
  • currency
  • date
  • status
  • payment_methods
  • client
  • client.email
  • client.name
  • client.contact
  • item
  • item.description
  • item.unit
  • time
  • time.description
  • expense
  • expense.description
  • mileage
  • mileage.description
  • comments

Amount Modifiers

Note: (X)= less, more

<

ul>

  • amount_(X) – Main amount field
  • due_(X)
  • item.quantity_(X)
  • item.rate_(X)
  • item.amount_(X)
  • time.quantity_(X)
  • time.rate_(X)
  • time.amount_(X)
  • expense.amount_(X)
  • mileage.quantity_(X)
  • mileage.rate_(X)
  • mileage.amount_(X)
  • <

    ul>

    Date Modifiers

    Note: (X)= on, after, before, during

    • date_(X) – Main date field
    • expire_(X)
    • created_(X)

    3. Bills

    Basic Search Fields

    • id
    • no
    • po_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • amount
    • client.email
    • client.name
    • client.contact
    • item.description
    • time.description
    • expense.description
    • mileage.description
    • tag.name
    • tax.name
    • discount.name
    • shipping.name
    • payments.status

    Text Modifiers

    • id
    • no
    • ref_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • client
    • client.email
    • client.name
    • client.contact
    • item
    • item.description
    • item.unit
    • time
    • time.description
    • expense
    • expense.description
    • mileage
    • mileage.description
    • tag.name
    • tax.name
    • discount.name
    • comments
    • payment
    • payment.status
    • payment.receipt_no
    • payment.payment_method
    • payment.details

    Amount Modifiers

    Note: (X)= less, more

    • amount_(X) – Main amount field
    • due_(X)
    • item.quantity_(X)
    • item.rate_(X)
    • item.amount_(X)
    • time.quantity_(X)
    • time.rate_(X)
    • time.amount_(X)
    • expense.amount_(X)
    • mileage.quantity_(X)
    • mileage.rate_(X)
    • mileage.amount_(X)
    • payment.amount_(X)

    Date Modifiers

    Note: (X)= on, after, before, during

    • date_(X) – Main date field
    • due_(X)
    • payment.(X)
    • created_(X)

    4. Recurring Invoices

    Basic Search Fields

    • id
    • no
    • profile
    • profile_id
    • po_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • amount
    • client.email
    • client.name
    • client.contact
    • item.description
    • time.description
    • expense.description
    • mileage.description
    • tag.name
    • tax.name
    • discount.name
    • shipping.name

    Text Modifiers

    • id
    • no
    • profile
    • profile_id
    • po_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • client
    • client.email
    • client.name
    • client.contact
    • item
    • item.description
    • item.unit
    • time
    • time.description
    • expense
    • expense.description
    • mileage
    • mileage.description
    • comments

    Amount Modifiers

    Note: (X)= less, more

    • amount_(X) – Main amount field
    • item.quantity_(X)
    • item.rate_(X)
    • item.amount_(X)
    • time.quantity_(X)
    • time.rate_(X)
    • time.amount_(X)
    • expense.amount_(X)
    • mileage.quantity_(X)
    • mileage.rate_(X)
    • mileage.amount_(X)

    Date Modifiers

    Note: (X)= on, after, before, during

    • start_(X) – Main date field
    • due_(X)
    • created_(X)

    5. Recurring Bills

    Basic Search Fields

    • id
    • no
    • profile
    • profile_id
    • po_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • amount
    • client.email
    • client.name
    • client.contact
    • item.description
    • time.description
    • expense.description
    • mileage.description
    • tag.name
    • tax.name
    • discount.name
    • shipping.name

    Text Modifiers

    • id
    • no
    • profile
    • profile_id
    • po_no
    • summary
    • note
    • currency
    • date
    • status
    • payment_methods
    • client
    • client.email
    • client.name
    • client.contact
    • item
    • item.description
    • item.unit
    • time
    • time.description
    • expense
    • expense.description
    • mileage
    • mileage.description

    Amount Modifiers

    Note: (X)= less, more

    • amount_(X) – Main amount field
    • item.quantity_(X)
    • item.rate_(X)
    • item.amount_(X)
    • time.quantity_(X)
    • time.rate_(X)
    • time.amount_(X)
    • expense.amount_(X)
    • mileage.quantity_(X)
    • mileage.rate_(X)
    • mileage.amount_(X)

    Date Modifiers

    Note: (X)= on, after, before, during

    • start_(X) – Main date field
    • due_(X)
    • created_(X)

    6. Network

    Basic Search Fields

    • id
    • category_name
    • organization_name
    • first_name
    • last_name
    • connection_name
    • currency
    • phone
    • mobile
    • city
    • zip_code
    • country
    • email
    • language
    • website
    • address
    • state
    • custom_fields
    • contact

    Text Modifiers

    • id
    • category_name
    • organization_name
    • first_name
    • last_name
    • connection_name
    • currency
    • phone
    • mobile
    • city
    • zip_code
    • country
    • email
    • language
    • website
    • address
    • state
    • custom_fields
    • contact

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    7. Files

    Basic Search Fields

    • extension
    • name
    • uploader
    • size

    Text Modifiers

    • extension
    • name
    • uploader
    • size

    Amount Modifiers

    Note: (X)= less, more

    • size_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    7. Item Category

    Basic Search Fields

    • name
    • unit
    • description
    • price (or rate)

    Text Modifiers

    • name
    • unit
    • description
    • price (or rate)

    Amount Modifiers

    Note: (X)= less, more

    • price(or rate)_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    8. Task Category

    Basic Search Fields

    • name
    • rate

    Text Modifiers

    • name
    • rate

    Amount Modifiers

    Note: (X)= less, more

    • rate_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    9. Expense Category

    Basic Search Fields

    • name
    • rate

    Text Modifiers

    • name
    • rate

    Amount Modifiers

    Note: (X)= less, more

    • rate_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    10. Trip Category

    Basic Search Fields

    • name
    • rate

    Text Modifiers

    • name
    • rate

    Amount Modifiers

    Note: (X)= less, more

    • rate_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    11. Tags

    Basic Search Fields

    • name

    Text Modifiers

    • name

    Date Modifiers

    Note: (X)= on, after, before, during

    • created_(X)- Main date field

    12. Time Entry

    Basic Search Fields

    • description
    • date
    • status
    • duration
    • task
    • client.email
    • client.name
    • client.contact
    • tag.name

    Text Modifiers

    • description
    • date
    • status
    • duration
    • task
    • client.email
    • client.name
    • client.contact
    • tag.name

    Amount Modifiers

    Note: (X)= less, more

    • duration_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • date_(X)- Main date field
    • created_(X)

    13. Expense Entry

    Basic Search Fields

    • description
    • date
    • status
    • amount
    • expense
    • client.email
    • client.name
    • client.contact
    • tag.name

    Text Modifiers

    • description
    • status
    • expense
    • client.email
    • client.name
    • client.contact
    • tag.name

    Amount Modifiers

    Note: (X)= less, more

    • amount_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • date_(X)- Main date field
    • created_(X)

    14. Mileage Entry

    Basic Search Fields

    • description
    • date
    • status
    • distance
    • trip
    • client.email
    • client.name
    • client.contact
    • tag.name

    Text Modifiers

    • description
    • status
    • trip
    • client.email
    • client.name
    • client.contact
    • tag.name

    Amount Modifiers

    Note: (X)= less, more

    • distance_(X)- Main amount field

    Date Modifiers

    Note: (X)= on, after, before, during

    • date_(X)- Main date field
    • created_(X)
    Updated on July 19, 2017

    Was this article helpful?

    Related Articles