We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 37583
    • 34 Posts
    Hi,

    I was wondering.. does getPage pagination work with Rowboat snippet call that gets data from custom db table?

    I have a working snippet call for Rowboat and I tried to cmbine those two. First it worked but did output only 2 pagination pages. (Should have been a lot more.) I tried all over again but then output was ten (default) results on one page. So it ignored the getPager.

    This I tried:

    [[!getPage@articlePaging?
    &elementClass=`modSnippet`
    &element=`Rowboat`
    &table=`modx_custom_havainto`
    &tpl=`naytaLintuHavaintoTpl`
    &columns=`{"date":"aika","maara":"","nimi":"bongaaja","paikka":"","havainto":""}`
    &sortBy=`date`
    &sortDir=`DESC`
    &cacheResults=`0`
    &pageLimit=`5`
    &pageNavVar=`page.nav`
    ]]
    
    <div class="paginate">
    <span class="pages">Page [[+page]] of [[+pageCount]]</span>
    [[!+page.nav]]
    </div>



    This works fine:

    [[!getPage@articlePaging?
      &elementClass=`modSnippet`
      &element=`getResources`
      &showHidden=`1`
      &tpl=`blogipostaus`
      &limit=`2`
      &includeContent=`1`
      &includeTVs=`1`
      &processTVs=`1`
      &parents=`[[*id]]`
      &hideContainers=`1`
      &pageLimit=`5`
      &pageNavVar=`page.nav`
    ]]
    <div class="paginate">
    <span class="pages">Page [[+page]] of [[+pageCount]]</span>
    [[!+page.nav]]
    </div>

    This question has been answered by [email protected]. See the first response.

    • discuss.answer
      • 37583
      • 34 Posts
      Sorry! I found the answer myself. smiley

      http://rtfm.modx.com/display/ADDON/Rowboat.Rowboat