Smart Rule Name does not begin with issue

[jrickmd]

Trying to narrow down a smart group to NOT include certain records, but can’t get it to work like I expect. Here is a screen shot of the rule and the record that I think should NOT be showing up.

If I change the “Name does not begin with” criteria to specifically be "6) " then the record does not get included in the selection. But leaving it as "[0-9]) " does include it… what am I getting wrong?

Rick

[pete31]

@jrickmd

If I change the “Name does not begin with” criteria to specifically be "6) " then the record does not get included in the selection. But leaving it as "[0-9]) " does include it… what am I getting wrong?

I tried that sometime ago:

@pete31

I’m trying to match record names that start with a date.

Works:

name:<2013-01-01

Fails:

name:<[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]

You’re not doing something wrong as …

@cgrunenberg

Only the “matches” condition supports operators & wildcards, other conditions like “begins/ends with” or “contains” are plain string queries.

… so you need to check for each digit independently.

Press the option key to create nested conditions:

[jrickmd]

Thank you! I did not find that thread in my search. Your help is much appreciated.

Rick

[cgrunenberg]

@jrickmd

If I change the “Name does not begin with” criteria to specifically be "6) " then the record does not get included in the selection. But leaving it as "[0-9]) " does include it… what am I getting wrong?

Exact string comparisons like is/contains/begins/ends (not) don’t support wildcards. NOTE: If operators and/or wildcards are supported by a field, then the placeholder of the empty field explicitly mentions this.