1 Reply Latest reply on Feb 15, 2017 11:46 AM by Doug Castell

    Filter not pulling correct results?

    hpadgett Rookie

      I have a filter - very simple: field abc begins with "customer"

      For some reason, the filter is returning results with field abc that do not even contain the word "customer".

      Upon further research, it seems it is pulling from field abc2016 rather than abc. The two fields are not connected in any way (that I can see).

      I have deleted and rebuilt this simple filter, yet it keeps pulling from abc2016.

      Ideas?

      Thanks!

        • 1. Re: Filter not pulling correct results?
          Doug Castell Expert

          Could be that the two fields share such a similar label that the wrong one is being selected when you select the label in the filter builder?

           

          Maybe building the filter via the search center would be simpler.  Just double-click the label of field ABC on your contact record screen and enter the criteria in the resulting search center window.  With the criteria/results up, you can use the button in the upper-left of the search center to select to Save that as a Filter.

           

          Of course, that's fine for a simple criteria, but if you needed parenthesis or had an otherwise more complicated filter, you'd need to use the full-fledged filter builder and figure out what's going on, field-selection-wise.