Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5F10090FD for ; Thu, 26 Apr 2012 12:40:43 +0000 (UTC) Received: (qmail 49540 invoked by uid 500); 26 Apr 2012 12:40:41 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 49499 invoked by uid 500); 26 Apr 2012 12:40:41 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 49411 invoked by uid 99); 26 Apr 2012 12:40:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2012 12:40:41 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of rathiar@gmail.com designates 209.85.213.42 as permitted sender) Received: from [209.85.213.42] (HELO mail-yw0-f42.google.com) (209.85.213.42) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Apr 2012 12:40:35 +0000 Received: by yhfq11 with SMTP id q11so1554944yhf.1 for ; Thu, 26 Apr 2012 05:40:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=mQj0drbGxZnfhCAhR8tL5SPnv2r6yc53GKylpIgKMbc=; b=uiIGWuhD6Vu+5djptAoukQo57aesaxMhWYoDSOfgvi6PRUBtSh/LMNu26t83hDBeap L0T5kZCDTV3Tkp9DQpJi6XxUZKzcENFOfSV2PK7Q0aiLf7UXFfGVV1St+5Eet20GOGvd uXMjdGy9TWsEK8Zah0zQLc/yecZc2sErWyzAdqbJ/QvmDoRLkp5G3crKs7tqVueQPbMy ul8rJYywr9F4MRoUrdClb0CyHofrSlqvq8zIjQdmNV30LKsjU+LN3MVEj5U9LM2p1rod +2VhYPASZbHf42WdQbbzRpguhMSiaAyuqgIWIpjWZIeTre9DB5WNMuLME1JRRtuzdqYP z5SA== MIME-Version: 1.0 Received: by 10.236.185.68 with SMTP id t44mr6203431yhm.126.1335444015023; Thu, 26 Apr 2012 05:40:15 -0700 (PDT) Received: by 10.236.125.166 with HTTP; Thu, 26 Apr 2012 05:40:14 -0700 (PDT) In-Reply-To: <7628B7424DEF784CA2ECB07668F69CF4801E5DCB@S-HQMX9.pmbelz.de> References: <7628B7424DEF784CA2ECB07668F69CF4801E5DCB@S-HQMX9.pmbelz.de> Date: Thu, 26 Apr 2012 18:10:14 +0530 Message-ID: Subject: Re: How to calculate size of data uploaded under certain node From: Anand Rathi To: users@jackrabbit.apache.org Content-Type: multipart/alternative; boundary=20cf303f69ae22061204be944a2c X-Virus-Checked: Checked by ClamAV on apache.org --20cf303f69ae22061204be944a2c Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Robert. I am already storing size as a custom property with every file uploaded. But then how can I calculate the total size under a node using aggregate functions? An example here would be really helpful. Currently I am doing it by visiting each node recursively and calculating the size. Regards, Anand On Thu, Apr 26, 2012 at 4:55 PM, Seidel. Robert wrote= : > Hi, > > by default, the size of data is not stored as property. > > A possible solution would be using a custom node type and add a property > for the size (and fill it). Then you can use aggregate functions in the > query. > > Regards, Robert > > -----Urspr=FCngliche Nachricht----- > Von: Anand Rathi [mailto:rathiar@gmail.com] > Gesendet: Donnerstag, 26. April 2012 12:44 > An: users@jackrabbit.apache.org > Betreff: How to calculate size of data uploaded under certain node > > Hi, > > I am using jackrabbit v2.2.5. I have hierarchy of nodes and uploading > files under those nodes. > > I want to measure the size of data uploaded under certain node. Is there > any way to get this? Is this possible using SQL or XPATH search? > > Thanks. > > Regards, > Anand > --20cf303f69ae22061204be944a2c--