Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 94185200C10 for ; Fri, 3 Feb 2017 14:16:43 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 92B32160B55; Fri, 3 Feb 2017 13:16:43 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id DD4AF160B48 for ; Fri, 3 Feb 2017 14:16:42 +0100 (CET) Received: (qmail 5201 invoked by uid 500); 3 Feb 2017 13:16:34 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 5191 invoked by uid 99); 3 Feb 2017 13:16:34 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Feb 2017 13:16:34 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id D3FE218231E for ; Fri, 3 Feb 2017 13:16:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 8FiptXdsq3vv for ; Fri, 3 Feb 2017 13:16:33 +0000 (UTC) Received: from mail-yw0-f179.google.com (mail-yw0-f179.google.com [209.85.161.179]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 6606E5F30A for ; Fri, 3 Feb 2017 13:16:32 +0000 (UTC) Received: by mail-yw0-f179.google.com with SMTP id w75so10942208ywg.1 for ; Fri, 03 Feb 2017 05:16:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=JbLZ257FtMWI1BvvCvu8rHTUuVSPD69iX5vydK35OyM=; b=Q1Z8Vfxh8SHJHljlSDR8dHXT7AptNW1/P2OKz2YFCjYHuWQ1hYz95UP5ejCFYy1e8e UwA59X5ug2LTkd4QEuBbN8IISJWgtszzkX6knDF5AclqINym57xbgcN+N6PxpD6tXfjG ZefjsvAvCSXD0Q5zwU4cbrsm+BQKYBrfwlQfeNH57D1rUnNycX52iUZ8jOHWX5v+j9iv 25h46vRTMgK9kvqiKf/wpWmICXej4w2qFYXw+FLEPP3J2n6m+fQoeenAHwBvtWTYn7M8 3afAtTtg5RAEKoylFpgOj0ipMR5pZ+V9HhvR2bo9ayHtzzKybiJFhB4J0s9bUY3inotW yDTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=JbLZ257FtMWI1BvvCvu8rHTUuVSPD69iX5vydK35OyM=; b=oK22QLCUVFU08OltANturAjmyzSuuftFExTn4Ar25UHSlfD0nqh5HXnytK7Y/J5od4 ho0PKsS9Cxbsze0aO9zoXkC034AmM2mQw8r0CnnisedUSrngSFt94vkqSwGa0miJW2yX k/lPOUCgyPDaBLIUS2tLmxug/sAVxo8jvmf3cG6GUgJ0WiPOGg7T/IYmHQ6BjPXlmt61 fuadZlH6YLMCqGrzRot4Ij4sucpkgCjVU/3bdADUSFGnbiUwv9CHBWTSMimy7+IkZJK9 fFLAYZNt4G6kpPUiW5Ovh8tGZ2/+LguDWrGnVq+ngsax1NZgXtExpiReO4R2etQy0G/+ UlPg== X-Gm-Message-State: AIkVDXJl8tHv3IQoz9rpTg3MsJ00qsoro5juqsrzPcWSoxwCgbmJEY9tIXKxEU9fm4UeljCRY7B8YGUIAKRRRg== X-Received: by 10.129.129.3 with SMTP id r3mr9359922ywf.0.1486127790130; Fri, 03 Feb 2017 05:16:30 -0800 (PST) MIME-Version: 1.0 Received: by 10.37.11.214 with HTTP; Fri, 3 Feb 2017 05:15:49 -0800 (PST) In-Reply-To: References: From: Sergi Vladykin Date: Fri, 3 Feb 2017 16:15:49 +0300 Message-ID: Subject: Re: Total Count with Paginated results To: user@ignite.apache.org Content-Type: multipart/alternative; boundary=94eb2c07dd3e05e23e0547a01780 archived-at: Fri, 03 Feb 2017 13:16:43 -0000 --94eb2c07dd3e05e23e0547a01780 Content-Type: text/plain; charset=UTF-8 Hi, Run two queries: one for counts, another one for results. Or fetch the result and count the rows along the way. Sergi 2017-02-03 13:40 GMT+03:00 Anil : > Hi, > > is there any way to get total count along with paginated results in ignite > ? > > I see no way in H2 db. thanks. > > Thanks. > --94eb2c07dd3e05e23e0547a01780 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Run two queries: one for counts, an= other one for results. Or fetch the result and count the rows along the way= .

Sergi

=
2017-02-03 13:40 GMT+03:00 Anil <anilklce@gmai= l.com>:
Hi= ,

is there any way to get total count along with paginat= ed results in ignite ?

I see no way in H2 db. than= ks.

Thanks.

--94eb2c07dd3e05e23e0547a01780--