Thanks , It does return *when* paging related params are passed. I have now used that result in my code.
Kind Regds mallah. > Hi, > > it does return it in the totalcount property by default. > > The name can be configured with the 'total_entries_arg' config parameter: > https://metacpan.org/pod/Catalyst::Controller::DBIC::API#count_arg,-page_arg,-select_arg,-search_arg,-grouped_by_arg,-ordered_by_arg,-prefetch_arg,-as_arg,-total_entries_arg > > Best regards, Alex > > On 2017-03-19 18:38, Dimitar Petrov wrote: > Hello Rajesh, > > I usually have my own: MyApp::REST which extends > > package MyApp::REST; > use Moose; > use Try::Tiny; > use DBIx::Class::ResultSet::RecursiveUpdate; > use Scalar::Util qw( reftype ); > > BEGIN { extends 'Catalyst::Controller::DBIC::API::REST' } > > with 'Iris::Web::TraitFor::Controller::Datatables'; > > …. > > and later on modifier: > > > =head2 list_format_output > > Add more information about current search > > =cut > > after 'list_format_output' => sub { > my ($self, $c) = @_; > > if (!$self->has_errors($c) && $c->req->has_search_total_entries) { > my $current_result_set = $c->req->current_result_set; > > $c->stash->{ $self->stash_key }{last_page} = > $current_result_set->pager->last_page + 0; > $c->stash->{ $self->stash_key }{current_page} = > $current_result_set->pager->current_page + 0; > $c->stash->{ $self->stash_key }{entries_per_page} = > $current_result_set->pager->entries_per_page + 0; > $c->stash->{ $self->stash_key }{entries_on_this_page} = > $current_result_set->pager->entries_on_this_page + 0; > } > }; > > Best regards, > > > On Mar 19, 2017, at 09:28, Rajesh Kumar Mallah > <mal...@redgrape.tech<mailto:mal...@redgrape.tech>> wrote: > > Hi , > > We know that Catalyst::Controller::DBIC::API supports paging > via list_count , list_page and list_offset options and > its possible to fetch a page of a large result set. > > However what it does not seems to support is to tell > the View(caller) of how many records in total exists , ie > the total_entries of the Data::Page object. > > This compels us to make two queries one to get the total count > and another to get the paged result. > > Does this feature really does not exists or am I missing something? > > (The reason I love and thoroughly use Catalyst::Controller::DBIC::API is > that it allows me to be lazy :p ) > > regds > Rajesh Kumar Mallah. > > > > > _______________________________________________ > List: Catalyst@lists.scsys.co.uk<mailto:Catalyst@lists.scsys.co.uk> > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/ > > > > > _______________________________________________ > List: Catalyst@lists.scsys.co.uk<mailto:Catalyst@lists.scsys.co.uk> > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/ > > > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien > Handelsgericht Wien, FN 79340b > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > Notice: This e-mail contains information that is confidential and may be > privileged. > If you are not the intended recipient, please notify the sender and then > delete this e-mail immediately. > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* > _______________________________________________ > List: Catalyst@lists.scsys.co.uk > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/ > _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/