nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Count of objects in user's Personal workspaces

Baber_Amin

Hi,

anybody having report to Count of objects in user's Personal workspaces.

thanks in advances

Find more posts tagged with

Comments

Lindsay_Davies

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

Hi Baber

Try this...

select count(*) from dtree where ownerid = ( select id*-1 from kuaf where name = '<login_name>')

Regards

Lindsay

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 January 24, Tue 07:10
To: eLink Recipient
Subject: Count of objects in user's Personal workspaces

Count of objects in user's Personal workspaces

Posted by baber.amin@dolphinenergy.com (Amin, Baber) On 01-24-2012 02:06

Hi, anybody having report to Count of objects in user's Personal workspaces. thanks in advances

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Baber_Amin

Hi,

thanks for this query.

I want to understand as well how its working. Whats

id*-1 means?

and is it possible calculate the size of the content inside personal workspace?

Narasimha_Rao

Hi Baber,

You can give a try with the attached LiveReport.

Thanks and Regards,
Narsi
Supai Systems,
Bangalore, India.
e-mail : narsi@supaisystems.com
website: www.supaisystems.com

On Tue, Jan 24, 2012 at 2:18 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

RE Count of objects in user's Personal workspaces Posted byldavies@opentext.com (Davies, Lindsay)On 01-24-2012 03:47

Hi Baber

Try this...

select count(*) from dtree where ownerid = ( select id*-1 from kuaf where name = '<login_name>')

Regards
Lindsay
OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 January 24, Tue 07:10
To: eLink Recipient
Subject: Count of objects in user's Personal workspaces

Count of objects in user's Personal workspaces Posted by baber.amin@dolphinenergy.com (Amin, Baber) On 01-24-2012 02:06

Hi, anybody having report to Count of objects in user's Personal workspaces. thanks in advances
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center
[To post a comment, use the normal reply function]
Topic: Count of objects in user's Personal workspaces
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

LiveReport.rpt

Lindsay_Davies

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

Hi Baber

It means the value of ID is multiplied by -1

The OwnerID column represents the workspace/volume that 'owns' the item, i.e. contains.

All items in a given workspace have the same value for OwnerID.

The query finds the value for the User's workspace from the KUAF table.

Sizes are stored on the version rows for the content - DVersData.

So you need to join DTree to DVersData to sum that information.

There should be plenty of examples in this discussion forum and some in the LiveReports volume within your own Livelink/Content Server installation.

Browse online and you will soon pick up lots of hints for your future queries.

Regards

Lindsay

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 January 25, Wed 08:22
To: eLink Recipient
Subject: RE Count of objects in user's Personal workspaces

RE Count of objects in user's Personal workspaces

Posted by baber.amin@dolphinenergy.com (Amin, Baber) On 01-25-2012 03:21

Hi, thanks for this query. I want to understand as well how its working. Whats id*-1 means? and is it possible calculate the size of the content inside personal workspace?

[To post a comment, use the normal reply function]
Topic:	Count of objects in user's Personal workspaces
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Baber_Amin

Hi,

thanks for your reply.

One question here that all user's Personal Workspaces are under another Big workspace at the top? if Yes, what is its id?

I have seen parent id of all Personal ws folder is -1

Lindsay_Davies

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

A ParentID of -1 indicates that you are at the root of the volume, i.e. the workspace level.

There is no parent for a workspace/volume.

So it is represented as -1.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 January 26, Thu 12:13
To: eLink Recipient
Subject: RE RE Count of objects in user's Personal workspaces

RE RE Count of objects in user's Personal workspaces

Posted by baber.amin@dolphinenergy.com (Amin, Baber) On 01-26-2012 07:02

Hi, thanks for your reply. One question here that all user's Personal Workspaces are under another Big workspace at the top? if Yes, what is its id? I have seen parent id of all Personal ws folder is -1

[To post a comment, use the normal reply function]
Topic:	Count of objects in user's Personal workspaces
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center