Search Criteria

SOLVED

I want to do a search the excludes any Job that starts with the letter "C".

Is there a carrot or symbol that can be used as a wild card to maybe Not Equal to C* to filter them out?

As shown in the picture below I have some jobs that start with a zero and some that start with a P I want only both of those in my search results.

  • +1
    verified answer

    You can search for multiple values by separating each with a comma, so you could use Begins with and enter 0,P (no spaces between each value you are searching for).  The comma doesn't seem to work when using Range so I'm not sure how you could go about entering multiple ranges using the traditional approach.

    Another way to handle this with a bit more flexibility would be to create a new custom lookup with a new calculated field.  The goal of the field is to return a 1 or a 0 depending on how you want the field to be presented.  You could call it "Exclude P", "Exclude Record", or "Include Record".  You would then use this column in your filter, so you would have it set to be equal to either a 1 or a 0 depending on whether you make it inclusive or exclusive.

    To create the field using a "begins with" criteria, in the new field calculation, you would use MID(dat.[field name]$,1,1), but depending on whether it is inclusive or exclusive determines the operator you use when comparing against a value, either = or <>.

    Here is an example using item inquiry.

    This is what the list looks like unfiltered.

    Here it is filtered to exclude the items starting with "2".

    The purpose behind the calculation is to return a boolean value, either a 1 that means true or a 0 that means false.  The result of the calculation is then used to filter the records like any other field.

    When creating the lookup, you can even set filters in it so if you want to create a process specific lookup that always excludes the records, using my example above, you would do so like this.

    Now when the lookup is started, you'll see the Filters button is red, indicating filters are active.

  • 0 in reply to David Speck

    The Coma worked like a charm.  Thanks

    I want to say Thank You for taking the time to reply.  I also want to thank everyone on this space for being willing to help I have found this space to be filled with a lot of wonderful people.

    So Again thank You

    Have a wonderful Friday.