Jump to content


Photo

Filtering / Searching on integer/decimal fields using logic

search filter

  • Please log in to reply
1 reply to this topic

#1 chrisedwards

chrisedwards

    Advanced Member

  • Members
  • PipPipPip
  • 240 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.

Cheers,

Chris

#2 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,966 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.
Advanced_Search.jpg

Ray Stoeckicht
Zurmo Team
Try Zurmo Pro






Also tagged with one or more of these keywords: search, filter

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users