List of values limit?

When using the “Show list of values” feature while building a query condition, only the first 20,000 records show. This gets me up to about C in my alphabetical list. How can I get it to show me ALL the values? I tried raising the limit on # of rows in Supervisor, but the result was the same. Can this limit be raised? If so, how? Brian J. Moyer
Tools Support Analyst
Business Objects

(425) 603-8310 (Desk)
(206) 718-2327 (Access Line)


Listserv Archives (BOB member since 2002-06-25)

Moyer, Brian wrote:

When using the “Show list of values” feature while building a query condition, only the first 20,000 records show. This gets me up to about C in my alphabetical list. How can I get it to show me ALL the values? I tried raising the limit on # of rows in Supervisor, but the result was the same. Can this limit be raised? If so, how?

Are you sure you want your users to scroll through 20000+ rows of LOVs???

To increase the limit, try to re-run (redefine?) the LOV query…

Walter

Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at


Listserv Archives (BOB member since 2002-06-25)