2
Views
5
Comments
change source record list line count at run time
Question
Hello,

I need to show a list without paging.

Is there a way to disable the paging on a source record list? One solution would be to put the line count property to a very high value, but isn't there a more elegant way?

Thanks,

Kurt
UserImage.jpg
Diogo Nesbitt
Hy Kurt,

did you try to delete the RichWidgets\List_Navigation web block that is under that record list?
2017-01-10 15-48-58
Hélio Dolores
Staff
Hi Kurt,

You can set it to the query list length/Count.
Please notice that the query may also have a MaxRecords limit that (in your case) must be empty.

Regards,
HD
2017-01-10 15-48-58
Hélio Dolores
Staff
Hélio Dolores wrote:
Hi Kurt,

You can set it to the query list length.
Please notice that the query may also have a MaxRecords limit that (in your case) must be empty.

Regards,
HD
 
Unfortunately I have to contradict myself...
The optimizer uses this value to optimize the own query... so you will have to use a very big number.
There are other solutions, but much uglier :)

Regards,

HD

2018-09-22 14-36-02
Kurt Vandevelde
 
MVP
Hi Dolores,

I was able to use your method on 2 of my tables, but on a third one I get:

Error details:
Cannot compute Count for a data source that does not implement ICollection.

All 3 get their data from advanced queries. I don't see any difference in the properties of the query nor the source record list on screen.
For the moment, I solved it by putting a very high value.
Any idea what the above message could mean?
2017-01-10 15-48-58
Hélio Dolores
Staff
Hi Kurt,

I'm actually looking on it. This is an internal .Net error that happens when we have a table with line count = 0.
To avoid that it is better to keep with a very high value.

This should be fixed soon.

Best regards,
HD
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.