AnsweredAssumed Answered

constrain found set by omitting non-matching records

Question asked by robdownunder on May 30, 2012
Latest reply on Jun 2, 2012 by robdownunder

Title

constrain found set by omitting non-matching records

Your post

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 "<"
 

thanks,

rob.

Outcomes