` Printed Icetips Article

Icetips Article



Par2: Multiple field range limit
1999-12-01 -- Anton Novikov
 
> I would like to do a range with the 3 fields. I know that I can use Field1
> as a range and Field2 + Field3 as a Filter, but I would like to do the range
> with the 3 fields and not use the Filter .

    Actually all range limits are converted to filters :)

1. You can do it in BRWxx.ApplyFilter before the parent call:
  BRWxx.View{prop:Filter} = '(Field1=Something) AND (Field2=Something) AND
  (Field3=Something)'
  RETURN

Also you can use MESSAGE(BRWxx.View{prop:filter},'filter') to look at the
filter expression

2. Also you can do it in BRWxx.SetSort method, after parent call:
    SELF.SetFilter('(Field1=Something) AND (Field2=Something) AND
    (Field3=Something)','1')

Don't forget to bind appropriate vars.



Printed November 21, 2024, 1:05 pm
This article has been viewed/printed 35208 times.