How to show result after 1000 records. Its showing blank after 1000 records

Hi bhupen 

I think you can increase these limits via a Support request. However the limits themselves are there for performance reasons, and therefore the question it's more whether you are using the right approach for the problem being solved. The pagination parameters are there exactly for this reasons (rather than pulling a very large quantity of data in one call).

When you say that "it doesn't work" , what specifically is the problem you are running into? Is it an error, or the data being returned is not what you expect etc.. ?

Thanks

PaoloTThanks,  my first preference is to solve this using APIV2.

How to write following rest call with APIV2

 <#assign nots = restadmin( '/users/id/' + user.id + '/notifications?restapi.response_style=view&page_size=' + page + '&page=' + y).notifications />

Second option: is to put into pagination. Following is the code where i put pagination but its  not working and nor showing any error.:

 <#list 1..3 as y>
    <#assign page = notificationsPage * pageSize />
    <#assign nots = restadmin( '/users/id/' + user.id + '/notifications?restapi.response_style=view&page_size=' + page + '&page=' + y).notifications />
    </#list>

Red color text defined for pagination functionality.

Help is appreciated.

Hi bhupen 

I don't think notifications are currently part of LiQL - so it is not possible to use API v2 to retrieve this information. If they were, you would probably use the LIMIT and OFFSET keywords to paginate (as for any LiQL query)

Thanks,

PaoloT  okay fine. Can you please look into it why doesn't working this snippet for me. Although there is not showing any error.:

<#list 1..3 as y>
    <#assign page = notificationsPage * pageSize />
    <#assign nots = restadmin( '/users/id/' + user.id + '/notifications?restapi.response_style=view&page_size=' + page + '&page=' + y).notifications />
    </#list>

bhupen responding very quickly here ... have you had a look at using 'offset' as you're using the API? I think I've provided some code in an earlier thread. Have a look if you can find it and if it helps.

Hi bhupen 

I suggest you raise a support ticket - I've tried with myself on the Lithium community (using page size = 1 and page 1,2,3 etc..) and I always get the same notification (the latest) back  irrispectively of the page number I pass, so it suggest that there may be an issue with the call itself.

Thanks,

@OlivierS

thanks for replying. Yes I tried some method but unofortunately couldn't get success. Can I have offset/code  example if you can provide.

bhupen not sure if it applies in this specific scenario, but please find below an example using the offset in LiQL:

<#assign offsetmax=100/>
<#assign stoploop=false/>
<#list 0..offsetmax as i>
<#assign offset=10*i />
${offset}
<#assign apiVersion = "2.0"/>
<#assign query = "SELECT id, body, subject, view_href, post_time, post_time_friendly, replies.count(*), kudos.sum(weight), author, board FROM messages WHERE depth=0 ORDER BY conversation.last_post_time DESC LIMIT 10 OFFSET ${offset}" />
<#assign topics = rest(apiVersion, "/search?q=" + query?url).data.items![] />
<ul>
<#list topics as message>
<#if message.post_time_friendly??>
<#if (message.post_time_friendly?contains("m ago")) || (message.post_time_friendly?contains("h ago"))>
<a href="${message.view_href}">${message.subject}</a>&nbsp;[${message.post_time_friendly}]
<#else>
<#assign stoploop=true> 
</#if>
<#else>
<a href="${message.view_href}">${message.subject}</a>&nbsp;[${message.post_time?datetime?string}]
</#if>
</#list>
<ul>

<#if stoploop==true> <#break> </#if>
</#list>

OlivierS  Unfortunately lithium don't support API V2 for notification and also have capability for  page size only 1000. you used offset in API V2 it doesn't work for me.. Looking for other way to resolve. it..