When doing a manual find/search, results are always limited to 200.
then you need to scroll endlessly to see all records, bloody boring.
has anyone an easy workaround other than using datasetbyquery to get the full foundset at once? which is hardly compatible with a manual search anyway.
still wondering why this 200 limit is still there for every controller action? it should be up to us to decide how many records can be found (form parameter).
They are not limited to 200. Showing the records goes in chuncks of 200, that is something different.
Why do you think the Servoy client performance sooo wel over the internet? (even with slow connections??)
And other question: why should scrolling trough more than 200 records be fun???
Really, what are you doing than, when you scroll?
but oke, I think you can do this now, by; getDataSetByQuery() fill the result in a dataset and than do: controller.loadrecords(myDataSet)
But, if you receive one million records, be aware, this can take a while…
They are not limited to 200. Showing the records goes in chuncks of 200, that is something different.
Why do you think the Servoy client performance sooo wel over the internet? (even with slow connections??)
------------ I know, but when working locally, you can work with larger sets, this is why I’d like to set this value myself depending on the kind of use. going to the last one is a misery.
And other question: why should scrolling trough more than 200 records be fun???
Really, what are you doing than, when you scroll?
------------ imagine a spreasheet where you could not go at the bottom at once? makes me mad… when you need to inspect large tables, I make a script to load the whole table, but what a waste of time. Loading 200k lines takes 3s, so where is the problem? web? I don’t use it for this app.
but oke, I think you can do this now, by; getDataSetByQuery() fill the result in a dataset and than do: controller.loadrecords(myDataSet)
But, if you receive one million records, be aware, this can take a while…
I can check the dataset size before loading and this is what I do.
my problem is with a manual find which I must convert to a query to get records… boring while unlocking this 200 limit would avoid to write queries for everything.
Lesouef,
You can create a method to go to the last record.
var _nRecCount = databaseManager.getFoundSetCount(foundset);
foundset.getRecord(_nRecCount); // forces to load the records
controller.getSelectedIndex(_nRecCount); // jump to the last record
Attach this to a button and you’re done. Beware of very large datasets though.
true, this is less lines. and making a cust search method to replace the menu one works for manual searches, not bad.
but I’d like to know why servoy keeps this limit fixed…
HI Lesouef,
lesouef:
true, this is less lines. and making a cust search method to replace the menu one works for manual searches, not bad.
but I’d like to know why servoy keeps this limit fixed…
If you want it changed I suggest you file a feature request in Servoy’s support system.
I don’t think anyone else requested it yet and that is probably the main reason why it’s fixed (apart from perhaps technical reasons).
not sure this is useful, I already discussed the matter with Paul Bakker, and he said it’s fixed roughly. I’ll try again…
With Servoy’s support system I actually meant http://www.servoy.com/s and not so much the forum itself.
afaik, this is only bugs reporting, so I did it in forum / feature requests
The support system is for bug reports and feature requests. Just mark it as such (see Case Type field).