calculating size of folders

I am looking for a livereport as described below:'Level 1' folder having 3 foldersL1.1L1.2L1.3so when I run report and select folder 'Level 1' I should get result ase.g. L1.1 200kbL1.2 300kbL1.3 400kb Note: the above folders can have any number of sub levels having documents and it should give me size whatever documents are under those levels.

Find more posts tagged with

Comments

Craig_Stanley

Message from via eLinkWe have moved away from using Live reports and have started using MicrosoftSQL Reporting Services which is a free download from Microsoft (SQL EXpressToolkit). We have encountered performance issues running LiveREports. TheSQL reporting services route is a better as you can include totals andcalculations and schedule these reports to run out of hours.We did have a similar requirement that we have got around using this optionselect d.*, NW_LL_getdocownername(d.dataid) owner,NW_LL_getreviewdate(d.dataid) reviewdate, NW_LL_getdocownerid(d.dataid)ownerid, NW_LL_GETOWNERRIGHTS(d.dataid) maxrights,NW_LL_GETFOLDERNAME(d.parentid) folder from dtree d where (d.subtype = 144or d.subtype = 136) and d.parentid in ( SELECT dataid FROM DTREE wheresubtype = 0 or subtype = 136CONNECT BY parentid = PRIOR dataid START WITHdataid = ********)order by NW_LL_getdocownername(d.dataid)Let me know if you need any help with this.Craig StanleyInformation ServicesNorthumbrian Watercraig.stanley@nwl.co.uk|---------+-------------------------------------------->| | "eLink Discussion: Open Text Live|| | Reports Discussion" || | || | || | 12/08/2009 09:44 || | Please respond to "eLink || | Discussion: Open Text Live || | Reports Discussion" || | ||---------+--------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "eLink Recipient" | | cc: | | Subject: calculating size of folders | >------------------------------------------------------------------------------------------------------------------------------| calculating size of Posted by dolene01user3 (user3, dolene01) on folders 2009/08/12 04:39 I am looking for a livereport as described below: 'Level 1' folder having 3 folders L1.1 L1.2 L1.3 so when I run report and select folder 'Level 1' I should get result as e.g. L1.1 200kb L1.2 300kb L1.3 400kb Note: the above folders can have any number of sub levels having documents and it should give me size whatever documents are under those levels. [To reply to this thread, use your normal E-mail reply function.] Discussion: Open Text Live Reports Discussion Livelink knowledge-wlweb01 Server: To Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.E-MAIL INFORMATIONThis e-mail was received by the Northumbrian Water servers on Wed, 12 Aug2009 08:44:58 UT. At this point it was checked for all known viruses andthreats.You are reminded that there is no guarantee that the information containedwithin this e-mail is genuine. It is not possible to verify the originalsender of this e-mail, or to ensure that the information contained withinhas not since been altered.You are reminded that urgent or sensitive information should not be sentvia e-mail, as this is not a secure method of delivery.**********************************************************************Northumbrian Water and Essex & Suffolk Water - building our future together.Be generous with the water you drink, it's good for your health. But take care of the water you use, it's a precious resource. Don't waste it.Northumbrian Water Limited - Winners of the Queenâ€™s Award for Enterprise: Sustainable Development 2009 and Utility Company of the Year 2008. Ranked Platinum Plus in the Business in the Community Corporate Responsibility Index Top 100 Companies that Count and Big Tick Winners 2009 for Healthy Workplaces and Power in Partnership.This email and its attachments are intended for the addressee only and may be confidential or privileged. If this email has come to you in error, you should take no action based on it. Please return it to the sender immediately and then delete it.Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Limited.You should be aware that this email, and any reply to it, may need to be made public under right to know legislation, or in connection with litigation. Emails may also be monitored in accordance with our legal responsibilities.While Northumbrian Water Limited has scanned this email and its attachments for security threats, including computer viruses, we have no liability for any damage which you may sustain as a result of any such viruses. You are advised to carry out your own virus checks before opening any attachment.Northumbrian Water Limited, registered in England and Wales number 2366703. Registered office: Northumbria House, Abbey Road, Pity Me, Durham DH1 5FJ.www.nwl.co.uk

unknown_user3

actually we are using Oracle db

Craig_Stanley

Message from via eLinkThat's ok, so are we. You can configure Reporting Services to query yourOracle DB. This is working really nicely for us.Craig StanleyInformation ServicesNorthumbrian Watercraig.stanley@nwl.co.uk|---------+-------------------------------------------->| | "eLink Discussion: Open Text Live|| | Reports Discussion" || | || | || | 12/08/2009 10:21 || | Please respond to "eLink || | Discussion: Open Text Live || | Reports Discussion" || | ||---------+--------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "eLink Recipient" | | cc: | | Subject: actually we are using Oracle db | >------------------------------------------------------------------------------------------------------------------------------| actually we are using Posted by dolene01user3 (user3, dolene01) Oracle db on 2009/08/12 05:18 In reply to: Re calculating Posted by craigstanley (Stanley, Craig) on size of folders 2009/08/12 05:10 actually we are using Oracle db [To reply to this thread, use your normal E-mail reply function.] Topic: calculating size of folders Discussion: Open Text Live Reports Discussion Livelink knowledge-wlweb01 Server: To Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.E-MAIL INFORMATIONThis e-mail was received by the Northumbrian Water servers on Wed, 12 Aug2009 09:21:27 UT. At this point it was checked for all known viruses andthreats.You are reminded that there is no guarantee that the information containedwithin this e-mail is genuine. It is not possible to verify the originalsender of this e-mail, or to ensure that the information contained withinhas not since been altered.You are reminded that urgent or sensitive information should not be sentvia e-mail, as this is not a secure method of delivery.**********************************************************************Northumbrian Water and Essex & Suffolk Water - building our future together.Be generous with the water you drink, it's good for your health. But take care of the water you use, it's a precious resource. Don't waste it.Northumbrian Water Limited - Winners of the Queenâ€™s Award for Enterprise: Sustainable Development 2009 and Utility Company of the Year 2008. Ranked Platinum Plus in the Business in the Community Corporate Responsibility Index Top 100 Companies that Count and Big Tick Winners 2009 for Healthy Workplaces and Power in Partnership.This email and its attachments are intended for the addressee only and may be confidential or privileged. If this email has come to you in error, you should take no action based on it. Please return it to the sender immediately and then delete it.Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Limited.You should be aware that this email, and any reply to it, may need to be made public under right to know legislation, or in connection with litigation. Emails may also be monitored in accordance with our legal responsibilities.While Northumbrian Water Limited has scanned this email and its attachments for security threats, including computer viruses, we have no liability for any damage which you may sustain as a result of any such viruses. You are advised to carry out your own virus checks before opening any attachment.Northumbrian Water Limited, registered in England and Wales number 2366703. Registered office: Northumbria House, Abbey Road, Pity Me, Durham DH1 5FJ.www.nwl.co.uk

Bob_Guilford

Message from Guilford, Bob <BGuilford@hovensa.com> via eLink

eLink

Using SQL Reporting is an interestingapproach, thanks for putting the idea out.

It looks like your example uses custom functionsyou created in SQL server (NW_LL_getreviewdate, NW_LL_getownerid, â€¦). Or, am Imissing something? Also, what version of SQL server are you using?

Thanks

Bob

From: eLinkDiscussion: Open Text Live Reports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 12, 20095:11 AM
To: eLink Recipient
Subject: Re calculating size offolders

Re calculating size of folders		Posted by craigstanley (Stanley, Craig) on 2009/08/12 05:10
In reply to: calculating size of folders		Posted by dolene01user3 (user3, dolene01) on 2009/08/12 04:39

Message from <craig.stanley@nwl.co.uk> via eLink

We have moved away from using Live reports and have started using Microsoft
SQL Reporting Services which is a free download from Microsoft (SQL EXpress
Toolkit). We have encountered performance issues running LiveREports. The
SQL reporting services route is a better as you can include totals and
calculations and schedule these reports to run out of hours.

We did have a similar requirement that we have got around using this option

select d.*, NW_LL_getdocownername(d.dataid) owner,
NW_LL_getreviewdate(d.dataid) reviewdate, NW_LL_getdocownerid(d.dataid)
ownerid, NW_LL_GETOWNERRIGHTS(d.dataid) maxrights,
NW_LL_GETFOLDERNAME(d.parentid) folder from dtree d where (d.subtype = 144
or d.subtype = 136) and d.parentid in ( SELECT dataid FROM DTREE where
subtype = 0 or subtype = 136CONNECT BY parentid = PRIOR dataid START WITH
dataid = ********)order by NW_LL_getdocownername(d.dataid)

Let me know if you need any help with this.

Craig Stanley
Information Services
Northumbrian Water
craig.stanley@nwl.co.uk

|---------+-------------------------------------------->
| | "eLink Discussion: Open Text Live|
| | Reports Discussion" |
| | <livereportsdiscussion@elinkkc.op|
| | entext.com> |
| | |
| | 12/08/2009 09:44 |
| | Please respond to "eLink |
| | Discussion: Open Text Live |
| | Reports Discussion" |
| | |
|---------+-------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "eLink Recipient" <devnull@elinkkc.opentext.com> |
| cc: |
| Subject: calculating size of folders |
>------------------------------------------------------------------------------------------------------------------------------|

calculating size of Posted by dolene01user3 (user3, dolene01) on
folders 2009/08/12 04:39

I am looking for a livereport as described below:

'Level 1' folder having 3 folders

L1.1
L1.2
L1.3

so when I run report and select folder 'Level 1' I should get result as

e.g.
L1.1 200kb
L1.2 300kb
L1.3 400kb

Note: the above folders can have any number of sub levels having documents
and it should give me size whatever documents are under those levels.

[To reply to
this thread,
use your normal
E-mail reply
function.]

Discussion: Open Text Live Reports
Discussion

Livelink knowledge-wlweb01
Server:

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.
E-MAIL INFORMATION
This e-mail was received by the Northumbrian Water servers on Wed, 12 Aug
2009 08:44:58 UT. At this point it was checked for all known viruses and
threats.
You are reminded that there is no guarantee that the information contained
within this e-mail is genuine. It is not possible to verify the original
sender of this e-mail, or to ensure that the information contained within
has not since been altered.
You are reminded that urgent or sensitive information should not be sent
via e-mail, as this is not a secure method of delivery.

**********************************************************************
Northumbrian Water and Essex & Suffolk Water - building our future together.
Be generous with the water you drink, it's good for your health. But take care of the water you use, it's a precious resource. Don't waste it.

Northumbrian Water Limited - Winners of the QueenÃ¢â‚¬â„¢s Award for Enterprise: Sustainable Development 2009 and Utility Company of the Year 2008. Ranked Platinum Plus in the Business in the Community Corporate Responsibility Index Top 100 Companies that Count and Big Tick Winners 2009 for Healthy Workplaces and Power in Partnership.

This email and its attachments are intended for the addressee only and may be confidential or privileged. If this email has come to you in error, you should take no action based on it. Please return it to the sender immediately and then delete it.

Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Limited.

You should be aware that this email, and any reply to it, may need to be made public under right to know legislation, or in connection with litigation. Emails may also be monitored in accordance with our legal responsibilities.

While Northumbrian Water Limited has scanned this email and its attachments for security threats, including computer viruses, we have no liability for any damage which you may sustain as a result of any such viruses. You are advised to carry out your own virus checks before opening any attachment.

Northumbrian Water Limited, registered in England and Wales number 2366703.
Registered office: Northumbria House, Abbey Road, Pity Me, Durham DH1 5FJ.

www.nwl.co.uk

adarsh_lobo_(adarsh.lobo@shell.com_(Delete)_112626

Message from <Adarsh.Lobo@shell.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi,

You can try using 2 LiveReports (LR) for this requirement.

LR1 code:

Input:

Type: Container Prompt: Folder/Project

SQL:

select dataid "DataID", name "Name", '!~<a href="livelink.exe?func=ll&objId=43854620&objAction=runReport&inputLabel1='||dataid||'">DataSize</a>' "DataSize Details" from dtree where parentid=%1 and subtype = 0

Param %1: UserInput 1

Report Format: AutoLiveReport

Note: DataiD in bold is the object ID of LR 2

LR2 Code:

Input:

Type: Number Prompt: DataID

SQL:

select ceil(sum(datasize/1024)) "DataSize in KB" from dversdata where docid in (select dataid from dtree start with dataid=%1 connect by prior dataid=abs(parentid))

Param %1: UserInput 1

Report Format: AutoLiveReport

This should work!

Rgds,

Adarsh

-----Original Message-----
From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 12, 2009 7:21 PM
To: eLink Recipient
Subject: RE Re calculating size of folders

RE Re calculating size of folders Posted by bguilford (Guilford, Bob) on 2009/08/12 09:48
In reply to: Re calculating size of folders Posted by craigstanley (Stanley, Craig) on 2009/08/12 05:10

Message from Guilford, Bob <BGuilford@hovensa.com> via eLink

Using SQL Reporting is an interesting approach, thanks for putting the idea out. It looks like your example uses custom functions you created in SQL server (NW_LL_getreviewdate, NW_LL_getownerid, â€¦). Or, am I missing something? Also, what version of SQL server are you using? Thanks Bob From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 12, 2009 5:11 AM
To: eLink Recipient
Subject: Re calculating size of folders Re calculating size of folders

Posted by craigstanley (Stanley, Craig) on 2009/08/12 05:10

In reply to: calculating size of folders

Posted by dolene01user3 (user3, dolene01) on 2009/08/12 04:39

Message from <craig.stanley@nwl.co.uk> via eLink

We have moved away from using Live reports and have started using Microsoft
SQL Reporting Services which is a free download from Microsoft (SQL EXpress
Toolkit). We have encountered performance issues running LiveREports. The
SQL reporting services route is a better as you can include totals and
calculations and schedule these reports to run out of hours.

We did have a similar requirement that we have got around using this option

select d.*, NW_LL_getdocownername(d.dataid) owner,
NW_LL_getreviewdate(d.dataid) reviewdate, NW_LL_getdocownerid(d.dataid)
ownerid, NW_LL_GETOWNERRIGHTS(d.dataid) maxrights,
NW_LL_GETFOLDERNAME(d.parentid) folder from dtree d where (d.subtype = 144
or d.subtype = 136) and d.parentid in ( SELECT dataid FROM DTREE where
subtype = 0 or subtype = 136CONNECT BY parentid = PRIOR dataid START WITH
dataid = ********)order by NW_LL_getdocownername(d.dataid)

Let me know if you need any help with this.

Craig Stanley
Information Services
Northumbrian Water
craig.stanley@nwl.co.uk

|---------+-------------------------------------------->
| | "eLink Discussion: Open Text Live|
| | Reports Discussion" |
| | <livereportsdiscussion@elinkkc.op|
| | entext.com> |
| | |
| | 12/08/2009 09:44 |
| | Please respond to "eLink |
| | Discussion: Open Text Live |
| | Reports Discussion" |
| | |
|---------+-------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "eLink Recipient" <devnull@elinkkc.opentext.com> |
| cc: |
| Subject: calculating size of folders |
>------------------------------------------------------------------------------------------------------------------------------|

calculating size of Posted by dolene01user3 (user3, dolene01) on
folders 2009/08/12 04:39

I am looking for a livereport as described below:

'Level 1' folder having 3 folders

L1.1
L1.2
L1.3

so when I run report and select folder 'Level 1' I should get result as

e.g.
L1.1 200kb
L1.2 300kb
L1.3 400kb

Note: the above folders can have any number of sub levels having documents
and it should give me size whatever documents are under those levels.

[To reply to
this thread,
use your normal
E-mail reply
function.]

Discussion: Open Text Live Reports
Discussion

Livelink knowledge-wlweb01
Server:

To Unsubscribe from this Discussion, send an e-mail to
unsubscribe.livereportsdiscussion@elinkkc.opentext.com.
E-MAIL INFORMATION
This e-mail was received by the Northumbrian Water servers on Wed, 12 Aug
2009 08:44:58 UT. At this point it was checked for all known viruses and
threats.
You are reminded that there is no guarantee that the information contained
within this e-mail is genuine. It is not possible to verify the original
sender of this e-mail, or to ensure that the information contained within
has not since been altered.
You are reminded that urgent or sensitive information should not be sent
via e-mail, as this is not a secure method of delivery.

**********************************************************************
Northumbrian Water and Essex & Suffolk Water - building our future together.
Be generous with the water you drink, it's good for your health. But take care of the water you use, it's a precious resource. Don't waste it.

Northumbrian Water Limited - Winners of the QueenÃ¢â‚¬â„¢s Award for Enterprise: Sustainable Development 2009 and Utility Company of the Year 2008. Ranked Platinum Plus in the Business in the Community Corporate Responsibility Index Top 100 Companies that Count and Big Tick Winners 2009 for Healthy Workplaces and Power in Partnership.

This email and its attachments are intended for the addressee only and may be confidential or privileged. If this email has come to you in error, you should take no action based on it. Please return it to the sender immediately and then delete it.

Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Limited.

You should be aware that this email, and any reply to it, may need to be made public under right to know legislation, or in connection with litigation. Emails may also be monitored in accordance with our legal responsibilities.

While Northumbrian Water Limited has scanned this email and its attachments for security threats, including computer viruses, we have no liability for any damage which you may sustain as a result of any such viruses. You are advised to carry out your own virus checks before opening any attachment.

Northumbrian Water Limited, registered in England and Wales number 2366703.
Registered office: Northumbria House, Abbey Road, Pity Me, Durham DH1 5FJ.

www.nwl.co.uk

unknown_padmanabhan

Buddy,As we discussed, Hyperlink will work only if you do the following change in autoreport-run.htmlYou may find this at:\installdirectory\module\report_2_2_0\html\autoreport-run.htmlThere is a line to print the values to browser: `val` Change it to: `%Lval` Then on your first report, you may see the Hyperlink enabled. Else you can use your second report as Sub-report. However, the requirement is to see the size of the folder along with results displayed at Report. This i feel it might affect the performance while running the query through Live report. Your comments are highly appreciated.