Browse Range Limit Type and Higher Key Component

[Mike McLoughlin]

Is there any way to work round the absence of the Higher Key Component for browse range limits?

I have a key with 3 key fields

Terminated          BYTE
Assessor            STRING(50)
Learner            STRING(50)

I need to show a subset where terminated =0 and assessor= (selected name) - I can do it now by using the filter for assessor and the range limit for terminated.  But on 1000s of records users are reporting slow performance.

Any ideas much appreciated.

Mike

[Bruce]

Hi Mike,

Bear in mind that a Range is just a filter. Ultimately all the fancy "range" template variables are translated into a prop:filter for the view. So if you construct your filter right, then there's nothing you can't do.

For a bit of background on Views, and View Filters see
http://www.clarionmag.com/cmag/v11/v11n02views.html
(subscription required)

If your view is running slow with large amounts of data, then I recommend using just the filter, not the range, and posting both the key declaration (that you hope it will use) and the filter statement here so we can see if they match.

Cheers
Bruce