Jahia in English > jcr:sql pagination

0 (0 Good)
0 (0 Bad)

jcr:sql pagination

by  cachavez »  2012/03/20 05:17

Do anyone know if is possible to make pagination of the result of jcr:sql ?

I tried to set using the limit and offset, but it looks like is not working.

I'm using Jahia 6.5.1.0

--

Cheers.

Carlos Chávez.

 

  • jcr:sql pagination
    2012/03/20 05:17

    cachavez <p> Do anyone know if is possible to make pagination of the result of jcr:sql ?</p> <p> I tried to set using the limit and offset, but it looks like is not working.</p> <p> I&#39;m using Jahia 6.5.1.0</p> <p> --</p> <p> Cheers.</p> <p> Carlos Ch&aacute;vez.</p> <p> &nbsp;</p>

  • Number of messages  32
    Registration date Mar 20, 2012
    0 (0 Good)
    0 (0 Bad)

    Re: jcr:sql pagination

    by  pap@commaro.com »  2012/04/27 17:20

    Hello,

    can you give more information of what exactly you want to do ? When you use limit and offset of the jcr:sql tag, you should get just the results of the single page, but you will not get the information of how many results/pages there are all together.

    Actually you could also use the ready out-of-the-box components called Pager and "JCR Query" (where you can enter a SQL2 statement) and then bind these two together.

    Regards,
    Benjamin

    Benjamin Papez (pap@commaro.com)

    Number of messages  220
    Registration date
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page