constrain found set by omitting non-matching records
I have a need to use "constrain found set" to hide some records that don't have a specific field value.
I've used "Find Requests" that look like this..
Omit RecordsAlpacas::Paddock: [>$paddock]
Omit RecordsAlpacas::Paddock: [<$paddock]
Let's say $paddock has the value "xxxyyy", then I get the desired effect of hiding records that aren't matching and keeping those that do match. Simple.
Now if $paddock contains "xxx yyy" I get no matches at all. The space is breaking this find.
I've tried escaping the space "xxx\ yyy", but that didn't work.
What am I overlooking here ?
Also, how come there's no "not equal" symbol I can use with omit instead of having to use ">" and then "<"