Allow query to match multiple values on a numeric field

Currently, I can create a query that matches for multiple values on a non-numeric field. For example, I can define a query that returns constituents in cities New York, Los Angeles and Miami, by specifying that City matches one of "New York", "Los Angeles", and "Miami", using the small "plus" (+) button after the text input field to make multiple value input fields appear.

However, I cannot do the same thing for a non-numeric field; the "plus" button option is not present. For example, if I have a numeric field that holds the US district number of a constituent, I can define a query that returns constituents for a single district. But I cannot define one that returns constituents from multiple districts.

The only way eTapestry currently allows such multi-value matching on numeric fields is to define multiple queries, each matching a single value of the numeric field, and then create a compound query out of them. This is a very clunky and time-consuming solution for such a frequently needed function. And unless there is some architectural quirk in eTapestry I'm not aware of, this feature should be very easy for Blackbaud  to implement -- certainly no more difficult than implementing it for non-numeric fields.

  • Guest
  • Mar 18 2019
  • Attach files