Paginate fetch related_objects

Next topic

Author	Message
Luc Chase	Friday 13 February 2009 7:36:00 am I'm performing a fetch relted_objects function and it's returning thousands of rows. I can see any offset or limit parameter options in that fetch function. I'd like to limit the number of row returned. Is there any code about that can help do this? or do I need to do the paging on the full returned result set? The Web Application Service Provider
justin kazadi	Friday 13 February 2009 7:56:40 am hi luc chase, i think this topic can help you. http://ez.no/developer/forum/setup_design/paging_reverse_related_objects The theory is when we know everything and nothing works. The practice is when everything works and nobody knows why. If the practice and theory are met, nothing works and we do not know why. Albert Einstein
Luc Chase	Friday 13 February 2009 8:46:25 am Excellent.. new feature just for me... almost. :-) Thanks! I was just about to try {$result= fetch(...) \| extract($offset, $limit) } which should work but probably much slower. The Web Application Service Provider

Author

Message

Friday 13 February 2009 7:36:00 am

I'm performing a fetch relted_objects function and it's returning thousands of rows. I can see any offset or limit parameter options in that fetch function.
I'd like to limit the number of row returned. Is there any code about that can help do this?
or do I need to do the paging on the full returned result set?

The Web Application Service Provider

justin kazadi

Friday 13 February 2009 7:56:40 am

hi luc chase,
i think this topic can help you.

http://ez.no/developer/forum/setup_design/paging_reverse_related_objects

The theory is when we know everything and nothing works.
The practice is when everything works and nobody knows why.
If the practice and theory are met, nothing works and we do not know why.

Albert Einstein

Luc Chase

Friday 13 February 2009 8:46:25 am

Excellent.. new feature just for me... almost. :-)
Thanks!

I was just about to try {$result= fetch(...) | extract($offset, $limit) }
which should work but probably much slower.

The Web Application Service Provider