6 Replies Latest reply on Jun 2, 2012 4:06 AM by robdownunder

    constrain found set by omitting non-matching records

    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.