[TYPO3-mvc] "Pagination and SQL statement"

[Henjo Hoeksma]

Hi Pallavi,

can't you just first fetch all the objects / uids with your complex query.
Then throw the uids in an array and do a normal repository method fetching
the objects based on their existence in the uids array. Not sure if it will
keep your grouping correct, but you could do some grouping in Fluid from
wherein you call the paginator widget.

Hope this helps.

Kind regards,

Henjo

Problems are small because we learned how to deal with them.
Problems are big because we need to learn how to deal with them.


On Mon, Dec 5, 2011 at 07:32, Pallavi Dhamapurkar <
pallavi.dhamapurkar at lelesys.com> wrote:

> Dear all members,
>
> I am aware that the pagination widget won't work with the custom
> repository query with the SQL statement. But still I would like to know if
> someone has already have some workaround. This is needed because there are
> some complex queries and the result needs pagination e.g. with GROUP BY
>  etc.
>
> Thanks in advance!
>
> --
> Thanks and Regards,
> Pallavi Dhamapurkar
> Software Developer (LAMP),
> Lelesys Infotech Private Ltd,
> Pune/Goa, India.
>
> Web: http://www.lelesys.com/home.**html <http://www.lelesys.com/home.html>
> Skype: pallavi_lelesys
> Phone: +91 832 2447500
>
> ______________________________**_________________
> TYPO3-project-typo3v4mvc mailing list
> TYPO3-project-typo3v4mvc@**lists.typo3.org<TYPO3-project-typo3v4mvc at lists.typo3.org>
> http://lists.typo3.org/cgi-**bin/mailman/listinfo/typo3-**
> project-typo3v4mvc<http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-typo3v4mvc>
>