>From Basic Admin Guide 6.x:
Max. Rows Specifies the maximum number of rows that will appear. If you enable chunking, this setting is ignored. If users select Refresh or Refresh Table, the maximum number of rows that the administrator defines is displayed. In Remedy User, if users select Refresh All in Table, the maximum number of rows that the administrator defines is ignored. (On web clients, there is no Refresh All function. For more information, see "Defining Table Labels properties" on page 299.) Note: For results list fields on the web, there is no default maximum for the number of items returned. If you do not specify a value greater than zero for Max. Rows, and if the Limit Number of Items Returned user preference is not selected, then the results list field will return unlimited items during a search. Make what you want to of the above. I tried the following scenario on MT 6.3: I had a table field which had 6 matching results. The table field has Max. Rows set to '5.' I refreshed the table field, and only 5 rows returned. I think they have fixed it in 6.x. You should upgrade :-) Gary ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Tuesday, February 13, 2007 1:37 PM To: [email protected] Subject: Re: Limit Number of Items Returned on the Midtier Thanks, Gary. You are right-the limit is controlled through the preferences form and it bleeds over to the midtier, too. However, that, ultimately, was not the source of my trouble. I figured out that if you set a max number of rows to be displayed in a table in version 5.1.2 of the midtier (don't know if this happens in 6.0+), if you refresh the table and, say, seven database records match the table's qualification, the midtier throws ARWARN 66!!! The client doesn't, but the midtier does. I'm curious to know if this happens in 6.3+. Norm ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, February 13, 2007 1:33 PM To: [email protected] Subject: Re: Limit Number of Items Returned on the Midtier I think you can use the AR System User Preferences form to control this on the web. https://......../AR+System+User+Preference/Default+Administrator+View/ You might give that a go, and this is on 6.3, so you might have different results. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CG/SCWOE Sent: Tuesday, February 13, 2007 1:13 PM To: [email protected] Subject: Limit Number of Items Returned on the Midtier Hi everyone: Please refresh my memory. I seem to recall there's a fairly easy way to limit the number of items returned when executing a search on the midtier. In the client it's an option setting that gets pushed to the user preferences form. How is the same reproduced on the midtier? My application is throwing the "The query matched more that the maximum number of entries specified for retrieval" (ARWARN 66) when I run my app in the midtier but I don't get it when running it in the client. Thoughts? Norm __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
