How to search currency amounts


Trackers can be used to tracked financial data with the Currency Amount Tracker Field.

In which case, you'll likely want to search the data. Where is this amount tracked?

If you are looking for a specific amount, you can do a search (in the global search box) with the currency. Valid format examples:

  • 498.33USD
  • 8.95CAD
  • 875CAD
  • 875.00CAD


This will work well with Manticore Search and Elasticsearch. To be tested with the MySQL and MariaDB indexes.