Pagination information in response

I have added a hook to alter views results before sending them to services for rendering. Please see services_views.api.php for example.

I think you can set $view->get_total_rows = TRUE; in one of views hooks. I would try hook_views_pre_build(). So no need services_views to interfere this variable in "case" of "hook_alter tries to get $view->total_rows".

I am not able to understand #2, #3, #4.
Please help me where do I need to put this code $view->get_total_rows = TRUE; to output pager informat(count, total rows) in response json , I tried like follwing:

function mymodule_services_views_execute_view_alter(&$output, $view) {
  if ($view->name == 'articles_response') {
    $view->get_total_rows = TRUE;
    $paged_output = array(
      'results' => $output,
      'total_rows' => $view->total_rows,
    );
    $output = $paged_output;
  }
}

But it didn't work,
I want something like this https://www.drupal.org/node/2301749 but code there is not working with views 3
Please help

So what is the variable or parameter to get the services_views module to output the view metadata with the result. I tried to use the hook_services_views_execute_view_alter(&$output, $view) and found that it did nothing at all. From what I can tell from adding watchdog logs, it doesn't even get called when requesting a view via services_views... What does one have to do to get metadata? Any guidance is appreciated.

I used the following and there was no change:

function myModule_services_views_execute_view_alter(&$output, $view) {
  $paged_output = array(
    'results' => $output,
    'total_rows' => $view->total_rows,
  );
  $output = $paged_output;
}

I also found that watchdog logs placed in services_views_execute_view, where the alter is initiated, are not called at all.

I had to create a new service to load pagination info after the services_views call was made. It would be nice if pagination info was included in the returned results.

I also tried the alternate path to getting a service with this module: using the individual view service (where you select the view in the services admin page as the resource)

On the plus side, the pagination information as refered to in the api finally showed up. The bad news is no arguments whatsoever are honored, so all of the following fail:

http://mysite.com/myview-service/myview?arg[0]=limit=1
http://mysite.com/myview-service/myview?limit=1
http://mysite.com/myview-service/myview?tid=1
http://mysite.com/myview-service/myview?filters[tid]=1

No arguments are honored. Any suggestions on what I might be doing wrong would be nice. Thanks

Hello,

I have the same problem with pagination and my_module_services_views_execute_view_alter hook is not the solution.

This hook allow to modify only the preview (when you are in B.O) !

However, services_views_retrieve() is used to send result to the endpoint.

I will try to find a good solution.

In order to make pagination work with services views which comes when you make a services display with path to access like

{endpoint}/{services display path} NOT FROM {endpoint}/views/{view name}

You have to configure EXPOSED OPTIONS from Pager settings link like the image attached

After that you must set ?offset=0&items_per_page=5 after you endpoint url like

{endpoint}/{services display path}?offset=0&items_per_page=5

NOTE : items per page must be like 5,10,20,50,100 and include items to display value.

You can enable the views php and write the following code :
if (!isset($static['size'])) {
foreach($view->result as $each_result) {
$result_array[] = $each_result->nid;
}
$size = count($result_array);
$static['size'] = $size;
}
return $static['size'];

This will return the total number of counts of result.

Another approach is to to user views_query_alter to get the total number of records and pass in the result array.

Checkout this article:
http://www.christophermchurch.com/services-views-api-add-on-module/

And this custom module made by Chris:
https://github.com/cmchurch/drupal_services-views-totals

Works beautifully!!

And this custom module made by Chris:
https://github.com/cmchurch/drupal_services-views-totals

Awesome, thanks!