noloco
asked on
Embedded view only displaying 1000 docs, but "&count=3000" - why?
Hi all,
I've asked a related question here recently that was resolved by my updating the index manually with Shift+F9.
However I have an embedded view in a form - a link opens the $$ViewTemplate form and sets the count=3000. There are about 2300 docs in the view but only the first 1000 display ON THE WEB.
I have tried changing the rows value also on the info tab of the embedded view to force it to open a maximum number of rows in the view, but that makes no difference.
I can't find any explicit reference anywhere to the 1000 (it may just be coincidence?!). Anyone have any ideas?
I don't think I'm breaking the max size of the view index either (130 MB) - how can I check if I am corssing that value?
Many thanks as always in advance,
nOLOco
-
I've asked a related question here recently that was resolved by my updating the index manually with Shift+F9.
However I have an embedded view in a form - a link opens the $$ViewTemplate form and sets the count=3000. There are about 2300 docs in the view but only the first 1000 display ON THE WEB.
I have tried changing the rows value also on the info tab of the embedded view to force it to open a maximum number of rows in the view, but that makes no difference.
I can't find any explicit reference anywhere to the 1000 (it may just be coincidence?!). Anyone have any ideas?
I don't think I'm breaking the max size of the view index either (130 MB) - how can I check if I am corssing that value?
Many thanks as always in advance,
nOLOco
-
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm sorry to say that 1000 is the maximum you can show in a view...embedded or not.. :-(
Have you tried clicking on the embedded view properties, and on the first tab, resetting the "Lines to Display" property? When I do that, and choose 3000, I am able to see everything.
That will not work!!! Max = 1000
No...that's not true. If you make sure on the first tab to show the view using the view's display property, then you can type in whatever amount of lines you want.
Note: If you choose to display the view using HTML or using Java Applet, you are more restricted.
I don't like to disagree with you mfay72 but I just tested the solution you suggested and it doesn't seem to work...
I agree that in that tab you could change the view properties to show 3000 entries(or more) but it doesn't seem to work :-(
It only works if you do what HemanthaKumar suggested and change the setting to 0....but....
Lotus states something about this problem:
"Count is limited by default to 1000 because displaying more than 1000 documents in an HTML view degrades performance."
The solution I created was:
I created two buttons(Back and Next) on the embedded view form with count commands in it(to show the next 200 documents, or the previous 200).I choose 200 because it gave me the best results in loading the view in the browser.
So noloco, in the end you have to combine the suggestions that HemanthaKumar and mfay72 suggested but be aware....this setting changed on the Server document is not just for one Database, but for all DB's on the Server...
and if you don't want to stress the Server that much you choose to show less documents in a view....
I agree that in that tab you could change the view properties to show 3000 entries(or more) but it doesn't seem to work :-(
It only works if you do what HemanthaKumar suggested and change the setting to 0....but....
Lotus states something about this problem:
"Count is limited by default to 1000 because displaying more than 1000 documents in an HTML view degrades performance."
The solution I created was:
I created two buttons(Back and Next) on the embedded view form with count commands in it(to show the next 200 documents, or the previous 200).I choose 200 because it gave me the best results in loading the view in the browser.
So noloco, in the end you have to combine the suggestions that HemanthaKumar and mfay72 suggested but be aware....this setting changed on the Server document is not just for one Database, but for all DB's on the Server...
and if you don't want to stress the Server that much you choose to show less documents in a view....
Well, I actually do have previous and next buttons, so maybe that's why I'm able to see everything...thanks for pointing that out.
ASKER
Well - sorry for not gettin back earlier - it might have prevented somewhat of a cat-fight. HemanthaKumar's original suggestion was spot on. As I've never been strong ont he Admin side - I wouldn't have known that (but should have guessed). All docs are now displaying (though it takes a while to load obviously). It's great thanks.
The forward/backward buttons are no good as this view is especially for printout purposes. Thanks for all suggestions y'all.
The forward/backward buttons are no good as this view is especially for printout purposes. Thanks for all suggestions y'all.
ASKER
SPOT ON Hemanth!!! - Once again I'm indebted to ya!!!
All the best,
noloco
All the best,
noloco
Anytime buddy!