Jump to content


Filtering / Searching on integer/decimal fields using logic

search filter

  • Please log in to reply
1 reply to this topic

#1 chrisedwards


    Advanced Member

  • Members
  • PipPipPip
  • 276 posts
  • LocationCanada

Posted 04 December 2012 - 05:44 PM

Let's say I want to find all companies with annual revenue less than $1,000,000. In the advanced search I've tried setting the search field as <1000000, but I end up with no results.

Is such a search something that would be easy to implement? Or perhaps it is already implemented but I don't know how to use it.



#2 raysto


    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 06 December 2012 - 03:47 PM

We don't have this functionality, but you will easily be able to do this when Reporting is completed (version 1.5: http://zurmo.org/roadmap). The best you can do now is create an Advanced Search and included "Annual Revenue" to the list view. Then click "Annual Revenue" so that you can sort by that value. Then paginate until you see all records above $1,000,000. Not ideal, but it gives you something.

Ray Stoeckicht
Zurmo Team
Try Zurmo Pro

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users