Displaying 2 objects in 1 line?

General_Dynamics_C4_Systems

Hi, Anybody know how if/how you can display 2 objects in a single row in a LiveReport? (LiveReport format) Example:select d.* from dtree d where subtype=144By having the d.* on there, you'll get a link to each document returned, along with the function menu. But, what if I want to have both the document as well as the parent object? Such as:select d.*, p.* from dtree d, dtree p where d.parentid=p.dataid and d.subtype=144The p.* throws an error instead of returning a clickable link with function menu to the parent object.Thanks.

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

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

Hi Anonymous

 

You can only have one item per line in a Livelink enabled Livereport.

 

Using your join technique, you can list the parent name if you wish on the same line.

In the additional columns section at the bottom of the edit screen you could add

     p.name     Parent Folder

for example.

 

Surely, you would do better to display the hierarchy, so the parent folder appears above the items it contains, not against each one.

 

If you are only displaying the direct children of a single folder, then presumably you allow the user to choose that folder from the input interface.

 

Either way, a user could always use the function menu to get to the properties for the chosen item and then navigate back up one level.

 

Lindsay

Open Text UK

 

---

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2010 February 01, Mon 23:38
To: eLink Recipient
Subject: Displaying 2 objects in 1 line?

 

Displaying 2 objects in 1 line?

Posted by genduser11 (C4 Systems, General Dynamics) on 2010/02/01 18:37

Hi, Anybody know how if/how you can display 2 objects in a single row in a LiveReport? (LiveReport format) Example: select d.* from dtree d where subtype=144 By having the d.* on there, you'll get a link to each document returned, along with the function menu. But, what if I want to have both the document as well as the parent object? Such as: select d.*, p.* from dtree d, dtree p where d.parentid=p.dataid and d.subtype=144 The p.* throws an error instead of returning a clickable link with function menu to the parent object. Thanks.