Query for documents in CS10.0

SIRFRAZ_Uhaque

Dear Friends,I am stuck in making a quey for our CS 10.0 which is integrated with SAP. The scenario is like this. When ever business is creating a sales order in SAP it is creating a BWS in CS10.0 by automatic BWS creation which is defined in SAP. In our Document template we have define 4 folders for every BWS.I want to frame a query which will give details like how many folders are empty in all sales order created between time 1 to time 2 by a specific users.Can some body help me in this, or if somebody can point where such issue is addressed?I am pretty new in live reports of CS10.0. Need some help on this.RegardsSirfraz

Hans Stoop

I can give the general approach:

 

First you need select the business workspace. All this information is in the table/view DTree. The subtype for a bws is 848.

 

To get the folders you need to join the BWSs via DTreeAncestors and select the children based on subtype = 0 and childcount = 0.

 

 

Hans Stoop
ECM Consultant  |  Professional Servcies

Open Text Software GmbH
Werner-von-Siemens-Ring 20
85630 Grasbrunn/München

Phone:	+ 49 (0)89 4629 1626
Mobile:	+49 (0)172 6770120
Website:	www.opentext.com

Place of Incorporation / Sitz der Gesellschaft:Open Text Software GmbH, Werner-von-Siemens-Ring 20, 85630 Grasbrunn, Germany | Phone: +49 (0) 89 4629 0 | Fax: +49 (0) 89 4629 1199 |Register Court / Registergericht: München, Germany | Trade Register Number / HRB: 179298 |VAT ID Number /USt-ID: DE 118 656 356 | Managing Director / Geschäftsführer:Gordon Davies, Paul McFeeters,Christian Waida

This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Mittwoch, 1. Oktober 2014 07:07
To: eLink Recipient
Subject: Query for documents in CS10.0

 

Query for documents in CS10.0

Posted bysuhaque@amiantit.com (Uhaque, SIRFRAZ) On 10/01/2014 01:03 AM

 

Dear Friends, I am stuck in making a quey for our CS 10.0 which is integrated with SAP. The scenario is like this. When ever business is creating a sales order in SAP it is creating a BWS in CS10.0 by automatic BWS creation which is defined in SAP. In our Document template we have define 4 folders for every BWS. I want to frame a query which will give details like how many folders are empty in all sales order created between time 1 to time 2 by a specific users. Can some body help me in this, or if somebody can point where such issue is addressed? I am pretty new in live reports of CS10.0. Need some help on this. Regards Sirfraz

---

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

 

image001.png